Optimize your blog with Revision Control

Post revisions we’re introduced with the release of WordPress 2.6. These are incredibly useful especially when you have a multi-author blog, but unfortunately this also increases the size of your MySQL database, which decreases the speed or your site.

If you have access to your database and know what you are doing, then an easy solution is to execute the following SQL statement:

DELETE FROM wp_posts WHERE post_type = "revision";

This simple SQL query will delete all of post revisions and, if you have a lot of posts, this may considerably reduce your database in speed up your blog.

An easier way to do it however, is by installing the revision control plugin. Once installed this plugin allows you to either disable or enable post revisions or what I like to do is to limit post revisions to the latest two.

This plugin is an ideal way to optimize and speed up your blog.