asked on
How to store the data in memory and make it accessible by all active sessions
Hi
I have a game which needs to show the ranking of the winner. there is a winner table and it needs to be updated per second.
In order to reduce the number of all active sessions to connect to the database, I would like to store the calculated result of winner table in memory.
How should I do that in VC#, ASP.NET and MSSQL 2005?
I have a game which needs to show the ranking of the winner. there is a winner table and it needs to be updated per second.
In order to reduce the number of all active sessions to connect to the database, I would like to store the calculated result of winner table in memory.
How should I do that in VC#, ASP.NET and MSSQL 2005?
.NET ProgrammingASP.NETMicrosoft SQL Server 2005
Last Comment
techques
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I use a windows service to update the table. Can i create the cache memory in windows service and let another web service to call that cache memory to retrieve the cache data and present it in aspx?
ASKER
I read http://www.codeguru.com/csharp/.net/net_general/performance/article.php/c10973__2/
and installed http://www.microsoft.com/downloads/details.aspx?FamilyId=4C557C63-708F-4280-8F0C-637481C31718&displaylang=en
But, how should I write the code for windows service to add and get data with caching?
I use MSSQL 2005, C#, dot net 2.0.
and installed http://www.microsoft.com/downloads/details.aspx?FamilyId=4C557C63-708F-4280-8F0C-637481C31718&displaylang=en
But, how should I write the code for windows service to add and get data with caching?
I use MSSQL 2005, C#, dot net 2.0.