What caching strategy do you use for a Database dependant ASP.NET App?

Question

Hi Folks,

I'm looking for a good caching strategy for an CRM App written in ASP.NET. Almost all sites depend heavily on the database, which means caching parts/the whole page for some time does not work in my situation. Is there any other way you use caching in these situations?

Thanks very much, Steve

Answer 1

We use caching for reference data that populates combo boxes and other fields(e.g. help fields) and any values that are unlikely to change frequently.

There are different levels of caching that are stored for different periods of time, including: Session (lifetime of the session) Application (lifetime of the web service)

Answer 2

It is a big idea to store all the content into the database. Yet, it is deficult to recall the content ,specially whenec for the script files. If you met this, I advise you use the **

CDN

** from misciroft.

Answer 3

What database engine?

For SQL Server, have you looked at SqlCacheDependency? Allows you to retain data sets and provides a cache invalidation mechanism based on notifications from the server. See The Mysterious Notification for an explanation how it works.