September 10, 2002

Optimize your SQL!

So I'm up just before 5:30am. Why? David Filo paged me because some database servers was pegged on CPU. I investigate. I find a couple of horribly un-optimized queries. They were doing full table scans due to lack of indexes. Even though the tables are essentially in RAM, that really CPU intensive, 'cause all the rows needed to examined.

The moral of the story: Optimize your SQL before running it on my servers and telling the whole world to look at it.

Grr. I guess I'm gonna be up for a while.

Posted by jzawodn at 06:09 AM