[GENERAL] Game Server Lags

2012-10-02 Thread Arvind Singh
we are all aware of the popular trend of MMO games. where players face each other live. My questions are focussed on reducing load on Game database or Sql queries a) How to control the surge of records into the GameProgress table. so that players get response quicker. The Server starts to lag

Re: [GENERAL] Game Server Lags

2012-10-02 Thread Craig Ringer
On 10/02/2012 10:02 PM, Arvind Singh wrote: we are all aware of the popular trend of MMO games. where players face each other live. My questions are focussed on reducing load on Game database or Sql queries In most cases the answer is the same as for any other bursty application: Cache

Re: [GENERAL] Game Server Lags

2012-10-02 Thread Peter Geoghegan
On 2 October 2012 15:02, Arvind Singh arvin...@hotmail.com wrote: we are all aware of the popular trend of MMO games. where players face each other live. My questions are focussed on reducing load on Game database or Sql queries a) How to control the surge of records into the GameProgress