02-18-2014, 08:36 PM
|
#19
|
Doing the wrong thing the right way since 2010.
Site and Game Administrator
Join Date: Jul 2007
Posts: 1,812
|
Re: Website/database question
Quote:
Originally Posted by Reincarnate
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.
|
Level1, Level2, Level3, .... Level2145
The table layout has changed over the years so indexes on older levels don't match the new levels.
Quote:
Originally Posted by Reincarnate
I thought having lots of small queries was technically a good thing with respect to datatable normalization?
|
It's generally bad.
Also since I've only learned this stuff working on FFR, I have no idea whats better. I just change the queries and time the results and pick the consistently fast one.
Last edited by Velocity; 02-18-2014 at 08:41 PM..
|
|
|