Re: Anyone with experience with MMOG and databases?

> 
> *Tony,*


Looking at a system that will be requiring 10,000+ simple writes per sec and 
> 20,000+ semi simple reads per sec.

 Interesting problem area. Why would you need to write that much to 
persistent storage (database)? My assumption is that you would just have 
some shared server processes that have a shared memory area. You only need 
to persist what must survive a server shutdown (or crash). In either case 
you'll lose all your active players, and they can start again. If that is 
not adequate, you might have some savepoints people could restart from. When 
a player first logs in you'll need some information about them, perhaps 
their preferences. My point is that slight compromises to the requirements 
can vastly reduce the database and server requirements.
 Dennis Williams

Other related posts: