Wang Kai

Personally I don’t like the “Post Revision” feature at all. It just creates tremendous useless post entries in wp_posts table every time I click on “Save” button while writing a post or page. Over time, the database may grows bigger and bigger.This is really not my style.

If you are also using WordPress 2.6 or newer version, and feel that post revisions feature is not that useful, there are ways to  turn it off. Just follow this simple 3-step way:

1. Open wp-config.php file which is located in the root or home directory of WordPress blog.
2. Add this line of code in wp-config.php: define(’WP_POST_REVISIONS’, 0);
3. Issue following clean-up SQL command: delete from wp_posts where post_type=’revision’;

Step 2 sets the constant WP_POST_REVISIONS to 0, indicating the revision feature to be turned off. Step 3 actually purges all post revisions related records in current database. This should give you a relative clean database environment (Wow~).

If you also suffice with AutoSave feature built-in in WordPress editor, then simply add another line in wp-config.php file: define(’AUTOSAVE_INTERVAL’, 600); This changes the interval of AutoSave trigger to be one hour, which should be long enough.