And finally, all the speed issues have been sorted out. The front page has gone from a max of 9 seconds several months ago to at most 650 milliseconds to load. Everything now runs nicely under a second, even the front page! No need for caching; this is still in real time. Now let's get this show on the road! For those who wonder: when I was grabbing the list of scanboxes and whether or not files were good or not, I was making one query per game/file (respectively). This meant lots and lots of database hits, which was making everything slow. I got rid of the scanbox mess a while ago (with Metal_Man88's help), but had kept the one query per file check until now. Lesson: don't hit the database too often. There are two issues here, but they are both irrelevant for now (and hopefully forever). The first issue is that this may mean the server is going to eat up memory (but I have a garbage collector which I hope will come in when the page has fully rendered and all the reference to everything are dropped) and have string operations all over the place, but 650ms max for the front page shows me this isn't a problem. The second issue is that because all information is transferred on all pages, even individual console pages, the individual console pages are going to take slightly longer to load because they pull in data they do not use. However, again, this is a negligible change (~100ms or so, I think).