Databases
StackOverflow2013
Postsdbo
POCalculate server requirements based on programming specs
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCalculate server requirements based on programming specs
    primarykey
    data
    text
    <p>Have you ever encountered something so easy to develop but stopped a while to think of server requirements for your project ? It is my case.<br/><br/> I want to compete with a gaming site, they have multiplayer Flash games like poker, rummy, backgammon, and other card games, 8 games in total. For each game they have rooms and tables. <br/><br/> I'll use Silverlight with Sockets. I already managed to develop the policy server, the Socket Server app using WinForms, the Client Socket app in Silverlight. I own a VPS for tests, so there is no problem in developing what I want, the problem is <strong>How to calculate server requirements, RAM, bandwidth, internet speed</strong> based on the following requirements:</p> <ol> <li>Server should support 24.000 users / day or 1000 users / hour</li> <li>Each game room should have it's own tables where users can play</li> <li>Users should not lose scores and game speed should be fast in general</li> </ol> <p>I just wonder how to handle the following situation: if 1000 users are connected through Socket connection to a room full of tables and one user leave a table, all 1000 users must be updated and UI should reflect the changes. Let's say that I'll update the clients by sending a small Message of 100 bytes to each user, this will eat 100 bytes * 1000 users = 100 kb, and this just for 1 UI change, for 1 Game and for 1 Room, not counting all my other games and rooms. Also 1000 iterations that sends bytes to clients should be very time consuming.<br/><br/>I am a developer, but not experienced in those situations. Please advice. Numbers will be great.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAlin Vasile
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCalculate server requirements based on programming specs
      1. USJustLoren
      1. VTFavorite
    2. VO
      singulars
      1. POCalculate server requirements based on programming specs
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POCalculate server requirements based on programming specs
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhy do you need a message of 100 bytes for 1 user leaving? Can you either 1) Assign ports for all messages, so if you receive any msg on port 5552 you'll know its for a user leaving. The msg will only be the id/ip.address of the leaving user. 2) Use compression or encryption techniques to make the message 10-25 bytes?
      singulars
      1. POCalculate server requirements based on programming specs
      1. USClick Upvote
    2. COmr. Click upvote, it's about games and tables, like yahoo online games where there are rooms and tables where you can site to play. imgine you see all tables in one page. now if someone leave a table, you need to update all clients by sending bytes from server to all clients.
      singulars
      1. POCalculate server requirements based on programming specs
      1. USAlin Vasile
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload