Hour 23. Optimizing Data Access

As the number of users of an application (Web or Windows forms) increases, the performance of the application is limited by its slowest part. The slowest piece of an application at any given time is referred to as the application's “bottleneck.” There will almost always be a bottleneck in your application because one component or another will always be slower than the others. In this hour, you'll see some effective techniques you can use to ensure that the data access portion of your application isn't the bottleneck.

In this hour, you'll learn

  • Some tips to improving your ADO.NET code for faster data access

  • How to use the tracing functionality in ASP.NET to locate bottlenecks in your application

  • How to use the SQL ...

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.