How Much Is DataReader Faster Than DataSet?
DataReader and DataSet connect to database on different ways when read data. It takes more time to create and populate DataSet than to create DataReader. DataReader is usually better solution when you need to show data. Real results depends of size of your database, your web server hardware, how well is your SQL query or stored procedure written etc.
Some practical tests shown that DataReader is two times or more faster than DataSet when read different queries on table with about 100 000 rows.
1. ASP.NET Page Life Cycle
2. What is Internet Information Server (IIS)?