So I have been watching the site really closely today and the performance has just been terrible. I went ahead and turned off the Bragging Rights stats, and was almost amazed at the performance jump. It makes sense… those stats do three queries for every data hit… and since the data rarely changes, it doesn’t make sense to do it that way.

So I will be building a cached model for that in my spare time. Hopefully I can get those stats back up and running in the next few days. For now, they are off line until I can complete the work.

I also noticed that the “watch lists” were running for every user, even when users didn’t have an entry in the watch list table… so I put in a little hack to solve that. I will be working on that data model too over the next few days to make it perform better.

Originally Syndicated via RSS from 360voice