Also, having a table for everything is VERY VERY bad practice, and IS frowned apon in the coding standards area. I mean you'd have 150 tables just for spawns, and that is rediculous. If you want spawns for just one zone you do a WHERE case to the statement like we do in the emu.
Now for the admin tools, they will always be slow. And it's not because they don't use threading, itbecause the myODBC and delphi mysql modules are VERY slow themselves. And there is nothing to fix that. To my knowledge the fastest forms of mysql handling are C++ (like EQEmu), and webscript (PHP, PERL..)
|