Tuesday, April 8, 2008

SQL Cache Dependencies

I did some reading on SQL Cache dependency with ASP.NET and it seems to be a really cool feature. I've implemented a cache over the data access layer before, but had to code in cache expiry on each update. It was a painful and time-consuming process. I heard about SQL Server Notification services at the time but since we were using Oracle, we were on a different boat. SQL Cache dependency works in one of two modes - either by notification (using the non-Express versions of SQL Server 2005) or by polling (works with all versions of SQL Server 2005). For a walk-through of an implementation of SQL Cache Dependency, check out the article at: http://www.ondotnet.com/pub/a/dotnet/2005/01/17/sqlcachedependency.html

No comments: