O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

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

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

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