Simpy Chichimichi

Exactly a week ago I posted about the recent performance improvements I made with Simpy. That's the green ellipse in the picture on the lft. People noticed the improved page load times and sent nice email. Needless to say, I was pretty happy. Then, all of a sudden, things again went down hill. That's the red circle in the picture. I starred at the database server for a while, and finally found a veerrry sloooowwwww querrrry. It turned out the query was not using the index it should have been making use of. Why not? Thanks to the fast and superb support found in the open-source community, I got help from database experts who quickly pointed me in the right direction. It turned out some of the statistics that the database server normally gathers was off by a large number. After I made the appropriate change, the database server load decreased by several orders of magnitude, as you can see in the picture below. The sudden drop in the chart represents the sudden drop of the load on the server. Of course, this nirvana won't last forever, and there will be new hurdles to jump over. That's just the nature of the beast. Until then, I'll be enjoying the speedier Simpy. As always, if you notice consistent slowness on any portion of the site, please let me know.