How to Optimize Your WordPress Database with One Click
When it comes to loading your site on the front end, WordPress is actually smart enough to ignore previous revisions as it loads individual pages. However, overall database bloat can slow down a site if you have a large site with many pages and posts. Post revisions do add to the overall size of a database but are certainly not the only contributor. That being said… anything that you can do to reduce the size of your database will keep your site running at peak performance.
Make space: When you edit a post or page on your website, WordPress automatically saves the new revision to the database. If you edit things a few times (and particularly if the post is long), your database soon gets clogged up with old revisions that just sit there, taking up valuable space. WP-Optimize removes these unnecessary post revisions, freeing up valuable Megabytes of data and increasing speed and efficiency. It also cleans up your comments table, removing all the spam and un-approved comments that have built up with a single click.
Optimize Your WordPress Database with One Click
Recently on twitter we found a great plugin called WP-Optimize which is a database cleanup and optimization tool. It allows you to remove post revisions, comments in the spam queue, un-approved comments, and much more with just few clicks. This plugin is a great plugin for Beginners because it does not require you to go to PHPmyAdmin.