Latest Tech and Tips

How to Disable Post Revisions in WordPress and Reduce Database Size

0

Post revisions is an excellent attribute that WordPress has to deal but also for some individuals it may not be the very best alternative. For individuals that have actually restricted database area, or for individuals producing WordPress as a CMS where they do not require autosave, they can merely disable Post Revisions attribute in WordPress by following this tutorial. By lowering the database size, you can additionally accelerate your website.

Open wp-config. php situated in your WordPress origin directory site and include the complying with code:

 specify(' AUTOSAVE_INTERVAL', 300 );// secs
specify(' WP_POST_REVISIONS', incorrect );

This code will certainly disable all future revisions to be conserved and it will certainly additionally boost your autosave period from 60 secs to 300 secs, so it indicates your post will certainly be autosaving every 5 min as opposed to every min.

The over code, will certainly not remove your previous revisions that are currently conserved in your database. To remove all previous revisions, you will certainly require to go to PHPMyAdmin and run the complying with SQL inquiry.

 DELETE FROM wp_posts WHERE post_type = "revision";

This need to disable Post revisions and remove all formerly conserved post revisions kept in your Database.

Disclaimer: We are not recommending that Post Revisions is a poor alternative. This tutorial is just for those that are in the scenario where they require to reduce their database size.