View Single Post
Old Dec 9, 2009, 06:11 PM
quintin3265's Avatar
quintin3265 quintin3265 is offline
Senior Member
Join Date: Mar 2009
Location: State College, PA
Posts: 193
Default Caching system implemented

I implemented the caching system I described yesterday. I was not able to test it fully before pushing it out, as this is a sort of emergency release. This weekend, I'll do more thorough testing to see if anything was broken by the change.

The disadvantage of this new system is that the grids are only updated every four hours. The song details pages are still real time. Previously, it took 2 minutes and 7 seconds to query the front page grids, while now the score grid takes about 0.8 seconds to query, a 100-fold improvement.

There are additional simple things I can do to get the load time down to 0.2 seconds or so, but I need to resume normal life for a little while. Please report any bugs.
Now you can embed your songs in forum posts and webpages just like this image! Click the image to find out how!