C# Programming
05-30-2009, 12:51 PM
Hello,
i have a little decision-problem http://www.barakasoft.com/script/Forums/Images/smiley_smile.gif
I create a new server-application which works together with client-applications. The Server-Application must manage the users, which are signed in and are online. So... how should i save this informations? Is it better to store it in the RAM (i make a List where the Classes with the UserInformations are in there), or should i better save them in a DB, where i have the passwords and so on too? My Problem is, i don't know how many users will use this client-application! There could be 100 users or 10 000 users!
But this wouldn't be the problem, the big problem is, that this server only exchange user-informations, and so if i have maybe 10 000 users and a lot of users asking for informations about other users i could get in trouble if i have the data in the RAM (maybe not enough RAM?) and if i have it in a DB i have a very big HardDisk IO! The TCP-Connections at last i MUST store in the RAM of course, so anytime i need informations in the RAM about my Users...
So, has somebody any idea which technique i should use to get the best performance out of it?
Many Thanks http://www.barakasoft.com/script/Forums/Images/smiley_smile.gif
i have a little decision-problem http://www.barakasoft.com/script/Forums/Images/smiley_smile.gif
I create a new server-application which works together with client-applications. The Server-Application must manage the users, which are signed in and are online. So... how should i save this informations? Is it better to store it in the RAM (i make a List where the Classes with the UserInformations are in there), or should i better save them in a DB, where i have the passwords and so on too? My Problem is, i don't know how many users will use this client-application! There could be 100 users or 10 000 users!
But this wouldn't be the problem, the big problem is, that this server only exchange user-informations, and so if i have maybe 10 000 users and a lot of users asking for informations about other users i could get in trouble if i have the data in the RAM (maybe not enough RAM?) and if i have it in a DB i have a very big HardDisk IO! The TCP-Connections at last i MUST store in the RAM of course, so anytime i need informations in the RAM about my Users...
So, has somebody any idea which technique i should use to get the best performance out of it?
Many Thanks http://www.barakasoft.com/script/Forums/Images/smiley_smile.gif