Data Access Performance Comparison

Date Published: 16 February 2005

Data Access Performance Comparison

My article on Data Access Performance Comparison with .NET, ASP.NET and ADO.NET was published today on In it, I compare the performance of several common data access techniques, including using DataReaders vs using DataTable or DataSet constructs. The one big surprise I ran into was just how much an open DataReader can cost on a busy site. The words instant death come to mind. One more reason why Iโ€™m not completely sold on only passing DataReaders between methods using delegates.

Thereโ€™s a download that didnโ€™t make it into the initial article where you can see all the source code and run the tests yourself. Iโ€™m uploading it and linking it now.

Steve Smith

About Ardalis

Software Architect

Steve is an experienced software architect and trainer, focusing on code quality and Domain-Driven Design with .NET.