02-18-2014, 08:29 PM
|
#17
|
x'); DROP TABLE FFR;--
Join Date: Nov 2010
Posts: 6,332
|
Re: Website/database question
Quote:
Originally Posted by Velocity
Each of FFR's levels are stored as a separate level in the database, so when doing levelranks, it grabs the entire song list, then loops every level getting your score from each table. So it ends up doing a massive amount of small queries. This is also why that page is cached for 15 minutes each time it's load.
It's terribly slow.
|
What's the smart way to do this? When you say it's a "separate level" in the database, do you mean a separate table? Like Level1 table, Level2 table, etc.
I thought having lots of small queries was technically a good thing with respect to datatable normalization?
|
|
|