Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database. In these comparisons, a reference set of methods is executed against a reference set of Customer, Order, and OrderDetail data under a range of user load conditions.
|