TechChee.com, shop online for gadget, gizmo and hot tech stuff

TechChee.com creates private this post to test

After several times of server outrage and we’ve created indexes on several major mysql tables of the Wordpress

This post is the private post just for testing if having created indexes will degrade posting/inserting/updating performance…

Our host has told us that TechChee.com has too many slow SQL queries. In fact these sqls are all from what Wordpress has. Suspected could be the site is growing with more and more content, without proper indexes on certain columns of heavily queried tables will cause those sql queries perform extremely slow, which would have caused many spikes in CPU’s load for our web host, and caused our site suspended….Hope those created indexes help improve the performance of the sql queries……

This entry was posted on Tuesday, April 22nd, 2008 at 11:40 am and is filed under Annoucement. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.