Speeding up WordPress
More like cleaning up WordPress, but anyway. I see this code all the time and I use it,but I can see how some people may get confused by it. So I am going to try and tell you how to modify it for your own WP database.The code below is pretty simple, but you cannot just copy and paste for it to work. You will need to be using PHPMyAdmin which you normally get from your hosting provider. Once inside here find your database on the left hand side and look for your WordPress tables.Normally your tables will look something like wp_posts, but if you are a little more secure then you will have changed the prefix wp to something else.The PREFIX is in red, make sure you change the red code below to your prefix.
DELETE a, b, c FROM <span class="red dark">prefix</span>_posts a LEFT JOIN <span class="red dark">prefix</span>_term_relationships b ON a.ID = b.object_id LEFT JOIN <span class="red dark">prefix</span>_postmeta c ON a.ID = c.post_id WHERE a.post_type = 'revision'
