Hour 23. Optimizing Data Access

for RuBoard

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 Query Analyzer to improve the speed of your database queries

for RuBoard