Help
Sign In
zaadz
October 2008 
Bad queries will getcha
Posted on Aug 20th, 2006
by 
Aeon
Aeon
Well,
In the past few weeks, I've had the pleasure of slowing down a bit. Since we launched biz and events, we decided to take a little time to go back over the code and clean things up.
I just updated the mail system today. Not too much in the way of new functionality. The really groovy stuff in under the hood.
Now, I know the majority of you out there aren't tech geeks... but Josh introduced me to this cool little utility 'mytop' today that lets you see all of the active queries going to the database. Well, I tell ya, I was surprised to see certain 'devil spawn' queries running upwards of 20 seconds before they completed.
I spend most of this morning tweaking queries and indexes and now the site is much faster... especially the mail system.
I'm happy. Lots more to come. Pretty soon I get to work on tweaking the site design ;)
-A
In the past few weeks, I've had the pleasure of slowing down a bit. Since we launched biz and events, we decided to take a little time to go back over the code and clean things up.
I just updated the mail system today. Not too much in the way of new functionality. The really groovy stuff in under the hood.
Now, I know the majority of you out there aren't tech geeks... but Josh introduced me to this cool little utility 'mytop' today that lets you see all of the active queries going to the database. Well, I tell ya, I was surprised to see certain 'devil spawn' queries running upwards of 20 seconds before they completed.
I spend most of this morning tweaking queries and indexes and now the site is much faster... especially the mail system.
I'm happy. Lots more to come. Pretty soon I get to work on tweaking the site design ;)
-A
Access: Public
