I wonder if all the sites don't share a common database? Immagine trying to process requests from all the sites put together? I notice in the links for items and such (at least for ffxi, wow, and eq2) none of the items share the same item code.
Just using random items pulled:
WoW item:
/db/item.html?witem=#
EQ2 item:
/db/item.html?eq2item=#
FFXI item:
/db/item.html?fitem=#
Notice all the items use the extension of /db/item.html? (I removed the first part of the http since they are different games and it doesn't matter what stylesheet you use technically... which also supports this theory)
So it seems that there is just a central DB server and every time you want to look up a quest/item/spell/whatever you have to send a query to it. With so many games and users on at any time, it isn't surprising that something like this has come up. If I am assuming right that is.
Maybe looking into a way to split the DB to seperate games, or say like 2 or 3 games? Would probably help loading times and reduce the strain. Again, assuming i'm right and your just running one main DB for all the games.
From what I know of data bases, something like that should work, as a properly programed/orgainized database is something to see in terms of what it can do.
Edited, Tue Oct 25 16:03:57 2005 by Tomec
____________________________
In a distant land, sink into the darkness...