title: card game engine with sql
body: <p>i am planning to create a card game engine using sql, the game consits of 4 human players and cards are in an sql table, now every thing is done regarding game logic and points, each game is manged by a seperate sql table, and players are able to create rooms</p>
  
  <p>each room shall have a game table contains cards data with each player represnted in a column and a seperate chat table</p>
  
  <ol>
  <li><p>if there was 1000 games running in the same
  time and each time a card played then a requst is made to the server
  either to remove a card from a players deck record player score and
  total game score, can this be handled in a single sql database
  without delayes and performance issues?</p></li>
  <li><p>can i use global temporary tables ##sometable for each game room or
      do i have to create the tables manually and delete them after the
      game ends?</p></li>
  <li><p>i would like also to know if storing chat data in a single sql
      table would make issues, one thing i thought of is saving chat data
      for all open rooms in a single datatable with a game id column, but
      would this give some performance issues if there was thausands of
      lines of chat data?</p></li>
  <li>also what about a database for each game, would that be an over
  kill?</li>
  <li><p>How such applications are managed normally?</p></li>
  <li><p>do i have to use multiple servers and distribute the running games
      on them?</p></li>
  <li>any ideas you have about optimizing such things</li>
  </ol>