Quote:
|
Originally Posted by John Adams
I would just like to get to the bottom of the optimization issues globally, because sometimes my zones take 2 secs to load, sometimes almost a full minute. That has to be data (mysql.exe pegged at 90%). This is even on raw PEQ, too
|
.
Seems to me, the more data you put into a zone is what affects the database. cbodmer mentioned the loot tables are what take longest to load, this makes sense, because I've found a lot of "stray" data in that area, that leads no where. It's like it's there, but the npc's that use it are not there anymore. So if you have a zone full of loots, and you load those loots, plus un- needed loots, then this could make more load than needed.
Trick is, how do you figure out what is the loot in use, and what is not, so it can be removed?