Chapter 12. Data Caching for Performance

One of the most common methods of increasing performance in an application is to provide data caching. Having the data available locally keeps you from repeatedly opening a database connection and making roundtrips to the server. Reducing the number of trips to the server means that more database resources and network bandwidth are available for other users and additional functionality. Caching can thus increase your overall performance.

Writing effective caching code can be quite a challenge because you need to know when the cache should expire (when the data is stale). For read-only data, this isn’t too difficult to determine because you can simply choose to refresh the data when the application is restarted. ...

Get Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.