Improve MMO Game Performance

Поиск
Список
Период
Сортировка
От Arvind Singh
Тема Improve MMO Game Performance
Дата
Msg-id BLU164-W3488616BC6BBD0E743F30DCA730@phx.gbl
обсуждение исходный текст
Ответы Re: Improve MMO Game Performance  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Re: Improve MMO Game Performance  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Improve MMO Game Performance  (Craig Ringer <ringerc@ringerc.id.au>)
Re: Improve MMO Game Performance  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: Improve MMO Game Performance  (Torsten Zuehlsdorff <foo@meisterderspiele.de>)
Список pgsql-general
we are all aware of the popular trend of MMO games. where players face each other live.
My area of concern, is storage of player moves and game results.
Using Csharp and PostgreSql
The game client is browser based ASP.NET and calls Csharp functions for all database related processing
 
To understand my query, please consider the following scenario
 we store game progress in a postgres table.
A tournament starts with four players and following activity
  1. Each player starts with 100hitpoints
  2. player 1 makes a strike (we refer to a chart to convert blows to hitpoints with random-range %)
  3. player 2 has 92HP, and returns a light blow, so player1 has 98hp
The above two round will now be in Game Progress Table, as
ROW Player1HP Player2HP Strikefrom StrikeTo ReturnStrikeHP Round TimeStamp StrikeMethod
1      100       100         0        0            0          0
2       98        92        P1        P2           2          1
There is a tremendous flow of sql queries,  
There are average/minimum 100 tournaments online per 12 minutes or 500 players / hour
In Game Progress table, We are storing each player move
    a
12 round tourament of 4 player there can be 48 records
    plus around same number
for spells or special items
    a total of
96 per tourament or 48000 record inserts per hour (500 players/hour)
Are there any particular settings or methods available to improve Just insert_table operations
 
thanks
arvind
 
 
 
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: stored procedure multiple call call question
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: moving from MySQL to pgsql