The problem with WordPress Revisions
Every single time you hit the “Save Draft” button, a new copy of your post gets saved. Then you hit “Save Draft” again and ANOTHER copy gets saved. Those old copies never ever get deleted. So let’s say you have 500 posts and hit “draft” 5 times on each post before you publish it. That means you actually have over 3,000 posts saved in your database! Every post takes up more space and can slow things down.
Ask yourself: do you need revisions?
I never, ever use the revision feature. Maybe some people completely depend on it, but I don’t. I have never wanted to revert back to an earlier version of a post. It’s just not the way I write. Therefore, revisions are completely useless to me and they’re just taking up extra space!
However, if you do use revisions, it’s still worth installing WP-Optimize. Just skip the next section on disabling revisions!
There is a small bit of code you can add to a WordPress file to disable post revisions. Connect to your site in an FTP client and open up the wp-config.php file. Look for the line that says:
/* That's all, stop editing! Happy blogging. */
And add this right above it:
// Disable post revisions define('WP_POST_REVISIONS', false );
Then save and re-upload this back to your server. Ta-da! Now WordPress will no longer create post revisions.
But that’s not all. All those revisions we talked about still exist in your WordPress database. Let’s get rid of those!
Install WP-Optimize to clean up your database
Install a plugin called WP-Optimize. This plugin will allow you to:
- Delete all post revisions
- Delete auto drafts
- Purge spam/unapproved comments
- Optimize your database tables
So install it and delete away! I deleted all my post revisions and I also optimized my database tables. I totally wish I took a screenshot beforehand, but I had THOUSANDS of post revisions! It was absolutely insane.