Why bother?

Post revisions have been part of WordPress since version 2.6. It is a feature that can save you from heartbreaks especially when you need to go back to a particular revision, or for comparisons between two posts. However it comes with a drawback as it can cause your SQL database to get bloated. Imagine if you have 500 posts and for every article you had 10 revisions, and that translates to bloating up your database 10 times. This is unnecessary especially if you are certain that your content does not need further changes and you have proofread it. In order to prevent your database from getting bigger unnecessarily, you got to remove or disable WordPress post revisions.

There are two ways to handle WordPress post revisions, either using WordPress plugins or by editing the wp-config.php file.

Method #1 – Removing or deleting the revisions using plugins

There are two free WordPress plugins that I recommend:


Optimize Database after Deleting Revisions
– after the first time setup on the plugin options, operating it is simply 1 click. The highly rated plugin is able to delete all revisions, or keep the number of revisions as indicated by you. At the same time, the tool also provides the ability to clean up your database. Depending on the size of your blog, you can save a few MB. You can further use this to delete your trash on comments, posts, pages, and more. Recommended to do this regularly to keep your your table clean and tight. More information here.

How to Remove or Disable WordPress Post Revisions WP-CleanWP-Clean – another popular choice when it comes to optimizing your SQL database. Other than removing the post revisions, WP-Clean is able to weed out duplicate tables, orphaned data, cleans up spam, remove deleted comments. Similar to the first suggested plugin, after setting up options, doing regular maintenance is easy and fast. Download the plugin here.

If you wish to keep the number of plugins you used or installed at a minimum, consider method #2 for a permanent solution to disable revisions on your WordPress.

Method #2 – Disabling, or limiting the number of revisions allowed

This method involves modifying the wp-config.php file contained inside your /public_html/ folder. If you are not comfortable or not experience in doing so, you may want to give this method a miss as it may cause your blog to crash or have errors popping up. It is recommended that you do a backup first before you proceed with this method. To modify your post revisions setting, you need to add in the following line into your wp-config.php

define('WP_POST_REVISIONS',3);

The above code is interpreted as keeping a maximum of 3 revisions, with the oldest revision being overwritten by the latest.

You can substitute the numeric “3”, with either of the following.

true (default), -1: store every revision
false, 0: no revisions are stored (except the one autosave per post)
(int) > 0:  number of revisions kept as per your indication (+1 autosave) per post.

*int means integer

If you wish to further optimize, or find out areas to improve on, check out some of the free online web tools I listed here.

FOLLOW

lincoln

Lincoln is a fan of Apple products, loves red wine and traveling. He blogs on internet marketing, social media, wordpress tips & guides, and using technology to maximize efficiency. Follow him on Twitter or Facebook for regular updates.
FOLLOW

Leave a Reply

Your email address will not be published. Required fields are marked *