Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Optimize Your Applications Expand / Collapse
Author
Message
Posted Thursday, February 10, 2005 3:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 2:39 AM
Points: 122, Visits: 103

Why aren't you using System.Web.Caching.Cache?  That way you can control the latency.

Post #160770
Posted Thursday, February 10, 2005 4:08 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 10:03 AM
Points: 577, Visits: 102

Good article...It's nice to see some C# code for a change.  this works well for small amounts of data (like lookup lists), as storing to much data in memory can seriously degrade performance.

When dealing with larger recordsets it's a good idea to cache to disk instead of memory.  The easiest way to do this in C# is using disconnected recordsets.  Basically, the data is serialized to disk as a XML recordset.

Of course, dealing with updates to data is an added layer of complexity, but this is a problem with any caching technique.  There are tons of solutions to this problem, though...they just take time to develop.

cl



Signature is NULL
Post #160974
Posted Thursday, February 10, 2005 8:48 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 15, 2013 6:22 PM
Points: 174, Visits: 99

Hi Malcolm,

Yes, you can use Cache instead of Session/Application. All store your live reference but Session with StateServer and SQL Server.  Have a look on this http://west-wind.com/weblog/posts/1214.aspx. This speaks about the way of storing objects by ASP.net with Cache and Session.

Dinesh

Post #160990
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse