O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics by Glenn Johnson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required