Month: June 2010

Upgrade to WordPress 3.0 – Few simple steps to do it yourself.

Last weekend, we have upgraded this Blog system to WordPress 3. It went well without any troubles, as expected. Our team shares few simple steps to do it yourself. 1. Download WordPress 3.0 from the URL wordpress.org/download. And before you install make sure you have access to the FTP client and MySQL database 2. Create a subfolder in your domain root folder and upload unzipped WordPress 3.0 files to the subfolder. Create a database for new WordPress version on …

We have 1217 bugs in our present blog system

When we launched our business/technical blog system under this domain/URL, it was done with WordPress version 2.7 and later we upgraded it to 2.9 (Carmen McRae release) last year. Now WordPress announced its version 3, with major revisions.  WordPress community announced that 1217 bugs were fixed (which means our present blog system has 1217 bugs) which is not a small number. It has 4 digits. 🙂 Next week, we will be upgrading to the new WP 3.0 and we then …

Tips for building better mySQL architecture

Have you thought about the right Data type which you should use? Is VARCHAR bad? Do you review the SQL statements that you have written? Do you know what sort of impact indexes produce? How to leverage the query Caching techniques? Do you follow the naming standards? This simple slide teaches you the best mySQL practices to be followed up by 15 minutes. Taking out the best from mySQL will improve the application performance if its part of …