|
The best way is to use multi threading that is constantly open and use stored procedures that que up everything and run them rather then open/close connections for everything everytime.
This was the system i added years ago to lotf 5017 ( and rewrote socket layer of course ) and made it stable without ever having login freeze nobody else seemed to ever be able to solve even years later lol
Any real game server uses threading and stored procs to save/read information to sql and CO is no different.
the 5165 source is no different put in new socket layer and system for stored procedures to database and i stress tested it at over 1k connections without crashing.
Co code is so easy ffs took me a whole 20-30 mins out of bordem to fix i really dunno why nobody else can make a stable source these days rather then add nothing but more content without fixing the underlaying base problems first. It was the same way with 5017 source years ago, All everyone ever cared about was adding more features instead of actually fixing it and it just made it crash that much faster. : /
|