StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhat to use for high-performance server coding?
text
Body
copied!<p>I need to build a server to accept client connection with a very high frequency and load (each user will send a request each 0.5 seconds and should get a response in under 800ms, I should be able to support thousands of users on one server). The assumption is that the SQL Server is finely tuned and will not pose a problem. (assumption that of course might not be true)</p> <p>I'm looking to write a non-blocking server to accomplish this. My back end is an SQL Server which is sitting on another machine. It doesn't have to be updated live - so I think I can cache most of the data in memory and dump it to the DB every 10-20 seconds.</p> <p>Should I write the server using C# (which is more compatible with SQL Server)? maybe Python with Tornado? What should be my considerations when write a high-performance server?</p> <p>EDIT: (added more info)</p> <ol> <li>The Application is a game server.</li> <li>I don't really know the actual traffic - but this is the prognosis and the server should support it and scale well.</li> <li>It's hosted "in the cloud" in a Datacenter.</li> <li>Language doesn't really matter. Performance does. (a Web service can be exposed on the SQL Server to allow other languages than .NET)</li> <li>The connections are very frequent but small (very little data is returned and little computations are necessary).</li> <li>It should hold most of the data in the memory for fastest performance.</li> </ol> <p>Any thoughts will be much appreciated :)</p> <p>Thanks</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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