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).

Check out their website and see complete details. Below is some features excerpted from the website:

* Modular, object-oriented core for easy extensibility
* Supports multiple database backends (MySQL, SQLite, PostgreSQL)
* Uses prepared statements throughout to protect against SQL injection attacks
* Media silos to directly access various ways of media storage, like Flickr, Viddler, or the server’s
filesystem
* Atom Publishing Protocol support
* Multiple users (authors)
* Multiple sites on one installation
* Support for static content (“pages”)
* Plugins
* Tagging
* Importers for Serendipity and WordPress

Screenshot:

This Wordpress plugin turns your normal search string from:

http://www.domain.com/?s=search-term

into

http://www.domain.com/search/search-term

This plugin removes the unnecessary “?” and converts spaces (%20) into plus sign “+”, making your wordpress search string more readable, and looks good for search engine optimization.

Click here to download this plugin.