On Thu, Jun 25, 2009 at 12:03 AM, <mobiledreamers@gmail.com> wrote: > GOals are to scale our game for 10000 simultaneous connection to db > right now db crashing at 500 or 1000 sim connections
Definitely look into pooling. I've got a pretty hefty database server (16 15k5 drives, HW RAID, 32Gig RAM and 8 cores) and I wouldn't DREAM of trying to handle 10,000 simo connections with it.