I thought the stats page was slow so I examined the queries involved.



The smilies query was a killer, especially when you have a 100k postings.



I further modified the existing queries to come up with a page that loads five times faster even after the removal of smilies.



To replace the smilies I added posts per day and signups per day.