ASP.NET 4 Unleashed

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 ...