January 17 2009
Turning off Post-Revision to Save Your Database

If you feel your wordpress blog is running slow, especially when you want to post a news, and if your blog is have more than hundred of posts, it might be your wordpress database is too large so that every query called from the admin panel or via your theme/template is slowly executed by the server.
To do some optimization I recommend using WP-DBManager plugin which provides this functionality as well as database backup, this is important for any blog installation. Database tables should be periodically optimized (and repaired if necessary) for optimum performance. Simply install the plugin if you don’t want to optimize it via such tools like phpmyadmin or any others.
WordPress 2.6 added a cool features when post version tracking mechanism was introduced. For example, every time you “Save” a post, a revision is written to the database. If you do not really need this feature you can easily turn it off by adding one line to your wp-config.php file, found in the installation directory of your WordPress site:
define(‘WP_POST_REVISIONS’, false);
If you have run a blog with revisions turned on for a while, chance is you will have a lot of revision posts in your database. if you wish to remove them for good, simply run this query (for example using the mentioned WP-DBManager) plugin.
DELETE FROM wp_posts WHERE post_type = “revision”;
This will remove all “revision” posts from your database, making it smaller in the 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.
Ever heard one blogging engine like this? It’s quietely new and few people have use it. The name itself is taken from swahili greeting which means What’s the news?. I haven’t try this one because when I try to install it on my localhost it doesn’t works, it said need php_pdo_mysql.dll extension to be activated (although I’ve already have it activated).






