|
What is SQL Cache Dependency in ASP.NET?- It is the mechanism where the cache object gets invalidated when the related data or the related resource is modified.
- It is a feature in SQL Server 2005 and SQL Server 2000.
There are three types of SQL-cache dependencies exist:
1. Other cache items.
2. Files / folders.
3. Dependencies on a database query.
- It can be used for both the application cache and the page output cache.
- It is used in a web garden (multiple processors on one version) or a web form (multiple servers running the same application).
- There is no need to have SQL knowledge to configure SQL cache dependency in your application and in SQL server.
- It is the simplest way to balance the performance gains of caching against data staleness.
|
