I have a pretty long list of results that will be accessed from an MSSQL database quite often from my users. I'm looking into options that will help optimize the time it takes to return this data. I'm looking into Singletons but wanted to know what other types of tricks there might be out there. I'd like to cache this data programmatically so that I can force a data refresh, or have a data refresh happen every time it is accessed beyond a certain age. Are there any good articles out there that might prove helpful?
The specifics of the data shouldn't matter too much, but it will be a list of objects I define.
AceCorban:
I'd like to cache this data programmatically so that I can force a data refresh, or have a data refresh happen every time it is accessed beyond a certain age
I do exactly this using singletons
Another way to do this is to use the Application object which is in scope for every page executing within an application. Seehttp://www.4guysfromrolla.com/webtech/111000-1.shtml for examples. This is probably the easier than the singleton method since asp.net builds it in.
Check out below two videos from this community
Caching in ASP.NET
Advanced Caching Methods.
HC
0 comments:
Post a Comment