Disable and Remove WordPress Revision Post Features
After WordPress introducing post revision features, it helps wordpress blogger to keep revision of post and restore to previous revisions anytime. However, too many revision stored on wordpress database might cause longer query time and processes database requests. That means, your blog will load slower and your visitors may wait longer before the content comes out. Beside that, greater revision post on wordpress also causes high CPU or memory load on your web hosting server.
So, there is many ways to delete revision wordpress post or stop the post revision on your wordpress platform. Over here i listed some trick to remove wordpress revision post and disable revision post on wordpress.
Tips to remove unwanted post revision and disable post revision features on WordPress:
1. SQL command to delete post revisions
I would assume you know how to login to your phpMyAdmin and know how to execute SQL command. So, simply run this SQL command and all stored post revisions will be deleted.
DELETE FROM wp_posts WHERE post_type = “revision”;
2. Use Delete Post Revision WordPress plugin

Delete Revision is a simple wordpress plugin that remove all revision post within few click. This wordpress plugin also automatically search for post revision on your wordpress database by pressing the Check Redundant Revision button.
3. Disable Post Revision features on WordPress
You can turn off post revision feature by go to your wp-config.php and adddefine(’WP_POST_REVISIONS’, false); before the closing ?> tag
How to Turn off WordPress Post Revisions:
- Login via an ftp client to the folder containing your WordPress site
- Copy the wp-config.php file to your desktop
- Using a text editor ( example :notepad), open the wp-config.php file
- Before the closing ?> tag, add the following line of code:
- Save the file and upload it to your server, overwriting the old file
define(‘WP_POST_REVISIONS’, false);
So, the above revision posts trick streamline your wordpress database, making it smaller in the query post process.
NOTE: Do this with care. If you are not sure what you are doing, make sure to at least create a backup of the database first or even better, ask a professional to help you. Remember, both the SQL command and delete revision plugin will delete all your post revisions, and you are not allow to choose which revesion to be deleted. So, please make sure you won’t regret after delete them!
Posted by km. Filed in Tips, Wordpress
Advertisement

Pingback: WordPress Plugin Releases for 04/04 | Weblog Tools Collection
Pingback: WordPress Plugin Releases for 04/04 « WordPress RSS
Pingback: WordPress Plugin Releases for 04/04 | BlogBroker24-7
Pingback: WordPress Plugin Releases for 04/04 « Wizreport
Pingback: WordPress Plugin Releases for 04/04 | bloground.ro - Blogging resources, WordPress themes and plugins for your development
Pingback: WordPress Plugin Releases for 4th April 2009 | patronit.net
Pingback: WordPress Plugin Releases for 4th April 2009 | PATRON.ORG.UK
Pingback: Weblog Tools Collection: WordPress Plugin Releases for 04/04 | Aslifm Blogu
Pingback: WordPress Plugin Releases for 04/04 - Word Press Magazine
Pingback: linkfeedr » Blog Archive » WordPress Plugin Releases for 04/04 - RSS Indexer (beta)