Monday, December 03, 2012

SQL Data Cache

http://msdn.microsoft.com/en-us/library/ms178604(v=vs.100).aspx Very good stuff. Cache data, but poll SQL Server for changes. Read the article above. http://www.codeproject.com/Articles/144344/Query-Notification-using-SqlDependency-and-SqlCach Service Broker issue http://msdn.microsoft.com/en-us/library/ms188798.aspx

1 comment:

Saravanan said...

Robert,
recently I read a book - Ultra-Fast ASP.NET 4.5, the chapter 3 explains caching in all tiers of the application, namely

Browser cache
ViewState
Cookies and web storage
Silverlight isolated storage
Proxy cache
Web server cache
SQL Server caching
Distributed caching
Cache expiration times