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
at

1 comment:

  1. Saravanan9:56 AM

    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

    ReplyDelete