http://wordpress.org/support/ WordPress › Support Topic: Delete old post, becouse DB is very huge en Tue, 24 Nov 2009 20:17:47 +0000 http://wordpress.org/support/topic/280053#post-1145166 Mon, 20 Jul 2009 19:32:39 +0000 alb3rt1 1145166@http://wordpress.org/support/ <p>I have got same problem. My Db is full with syndicated posts!<br /> I tryed auto-delete-posts-plugin but doesn't works on Db...<br /> Tryed Bulk delete plugin but doesn't works on wordpress 2.7 </p> http://wordpress.org/support/topic/280053#post-1103460 Sun, 14 Jun 2009 19:25:29 +0000 armyinfoforum 1103460@http://wordpress.org/support/ <p>I have few problems – described latter in the post – and possible solution – first in the post – I just need some experienced to check my future steps and to suggest me is it that good or bad idea – and maybe to give me tips where to find solution!</p> <p>I have blog beside SMF forum which is for multimedia and similar stuff. I use that blog also for aggregating rss messages – and I have it more than 35000 – now. I want to delete old posts but with some tweaks </p> <p>post must be private (all rss post are private – all others are published and must not be affected by this delete function), post must be older than 90 days, post can be in any category if it is private – it can be deleted – like I already mention all others post are published</p> <p>I am owner of my own server – and I can use MySql Query Browser which means I can do all those directly on MySql DB</p> <p>My DB is more than 350 Mb – which is really heavy – with every day backup I very easily fill the place on my hdd – not fast but – gradually. I think this will reduce my DB size because old post nobody looks any more .….</p> <p>I am not professional coder, but I have some little experience with working with db </p> <p>How will look command for that </p> <p>How to make command for deletion which will consist from checking status (private or published), and which will check date (if post is older than 90 days automatically it must be deleted)<br /> I suppose that if it is MUST that post is private – nothing other will be affected with that command</p> <p>Why I do those</p> <p>My publishing now are more and more problematic – and when I want to publish something – I simply must wait very long time for WordPress (I mean MySql) finish its job – it can be even 3-4 min long – just publishing – not to speak about editing that same post – it become painfully long and slow process</p> <p>For instance – my smf db has only 86 Mb and contains more that 40.000 posts or topics – whatever – this 35.000 posts in blog are 350 Mb in DB – which is very huge</p> <p>My both db – Smf and WordpresS are every day checked, compressed with backup on the end. – Any other suggestion which will be helpful are welcomed</p> <p>Thanks in advance<br /> Spel </p>