Efficient Data Retrieval

Overview

Take a look at how to optimize using Stored Procedures for efficient and secure data retrieval in the middle tier of your Web, Windows, mobile and Web services applications. Learn how to do crosstab queries for reporting that take seconds to execute instead of hours, exploiting sub-queries and taking advantage of self-joining. Explore performance tuning from the perspective of stored procedures used for data retrieval. Look at how to get a higher cache-hit ratio, efficient index creation and utilization and how to guarantee that ADO.NET takes advantage of these optimizations. Focus on squeezing the last bit of performance out of ADO.NET. Look at how to best architect your application to take advantage how ADO.NET was designed to work with data in a disconnected. Look at comparisons between the DataSet and the DataReader, and an explanation of the best use for each of these objects. Look at techniques for using multiple result sets in one DataReader or DataSet for efficient client databinding, using stored procedures for dynamic sorting, proper connection pooling, optimizing connections with the DataAdapter, and ExecuteScalar vs. ExecuteNonQuery comparisons.