Tuesday, March 31, 2009

Significant performance improvements

After the most recent update, it was pretty clear that some pages on the site were running really slowly. The biggest offenders were the calendar, workouts, and statistics pages. Tonight I started looking into it and found a very simple solution. I was just missing a database index.

PageBeforeAfter% Faster
Statistics15468 ms242 ms6392%
Calendar6896 ms117 ms5894%
View Workout791 ms23 ms1265%
Workouts2196 ms247 ms889%
View Team2782 ms319 ms872%
ms = millisecond

The site is ridiculously faster now. Enjoy.

0 comments: