Summary
In this hour, you learned some practical techniques for improving the speed and effectiveness of your application's data access. First, you saw some general techniques for tweaking ADO.NET to achieve faster data access. Then, you learned how to use the Trace object in ASP.NET to locate potential bottlenecks in your application. By using the SQL Query Analyzer, you can find out exactly why a database query is running slowly, and also some ways to improve the speed of the query. Lastly, data caching was used to reduce the number of repetitive calls to the database.
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.
