Using SQL Cache Dependencies
One of the most powerful features supported by ASP.NET Framework is SQL cache dependencies. This feature enables you to reload cached database data automatically whenever the data in the underlying databases changes.
There is a trade-off when you use either an absolute or sliding cache expiration policy. The trade-off is between performance and stale data. For example, if you cache data in memory for 20 seconds, the data displayed on your web pages might be 20 seconds out of date. In the case of most applications, displaying slightly stale data does not actually matter. For example, if you build a discussion forum, everyone can live with the fact that new posts might not appear immediately.
However, there are certain ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access