January 17 2009

Turning off Post-Revision to Save Your Database

wordpress

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.

November 17 2008

The Habari Project

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:

August 14 2008

Harley Davidson helmets

Are you a rider? you shuld have known how important is a helmet to protect you from getting injured while you’re riding your bike, but sometimes people think a rider especially a harley davidson rider looks pretty cool without helmet on their face, BUT NO, that’s NOT even cool at all, can you say he stay ‘cool’ when he lay down desperately on hospital with injured head and might getting risk of potential brain damage after he crashed out from his bike? so wear your helmet for your safety.

Good motorcycle helmet can offer a more enjoyable riding experience. Modern helmets today offer more than added features to help protect a rider’s head; they also offer comfort, ease of use, and excellent exterior designs. When buying helmets, several factors need to be considered.

* Comfort – no one likes helmets that are uncomfortable.
* Outer Shell – this should be hard and sturdy, but lightweight as well.
* Safety Liner – the substance that absorbs energy preventing it from reaching the head.
* Comfort Liner – the interior helmet padding where a rider’s head rests.
* Ventilation – air coming inside the helmet should also be able to get out.
* Locking system – a helmet won’t be much without one.
* Interior Space – is there space enough for your head and ears?
* Sunshade – built in, to shade the sun; wearing sunglasses does the trick too
* Weight – too heavy helmets are just so un-cool.
* Visor – make sure the visor does not interfere with your vision.

At mens Harley Davidson helmets you can find so many choices of harley davidson helmet for you to stay pretty cool but also safety on the road.

RSS
CmsHelpers.com

Hello and welcome to the new CMSHelpers.com!
This site offers a collection of website CMS Tools and a list of useful resources which will help you to build your own CMS site, blog, portal, or whatever you want, and also improve your web design skills.


Please feel free to have a look around and thank you for visiting this site!