How DataReader works?

by

I strongly suspect that the reader reads a batch of results at a time. That’s a lot more efficient than one row at a time (think about the situation where a single row is only a few bytes… you don’t want a network packet per row when it could have retrieved lots of rows in a single packet). It also potentially allows the database to release its internal resources early – if the data reader has read all the results (when there are only a few) it can effectively forget about the query.

I suspect if you try the same type of thing with a query returning lots of results, you’d get the expected exception.

More Related Contents:

  1. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  2. Determine if a number can be made with prepicked numbers and times
  3. MetadataException: Unable to load the specified metadata resource
  4. Path.Combine for URLs?
  5. Could not find a part of the path … bin\roslyn\csc.exe
  6. ASP.NET MVC Global Variables
  7. Printing to a client printer from a web app
  8. How to pass a table-value parameter
  9. How to set attributes values using reflection
  10. How can I remove item from querystring in asp.net using c#?
  11. ASP.NET MVC Razor render without encoding
  12. How to keep single SQL Server connection instance open for multiple request in C#?
  13. How do you bind an Enum to a DropDownList control in ASP.NET?
  14. No authenticationScheme was specified, and there was no DefaultChallengeScheme found with default authentification and custom authorization
  15. Encrypting Web.Config
  16. How can I handle forms authentication timeout exceptions in ASP.NET?
  17. MEF with MVC 4 or 5 – Pluggable Architecture (2014)
  18. How do I force full post-back from a button within an UpdatePanel?
  19. Multiples Table in DataReader
  20. ThreadStaticAttribute in ASP.NET
  21. Unable to find the requested .Net Framework Data Provider. It may not be installed
  22. Could not load file or assembly ‘System.Net.Http.Formatting’ or one of its dependencies. The system cannot find the path specified
  23. C# Clear Session
  24. How can I determine browser window size on server side C#
  25. How do I connect to a SQL database from C#?
  26. Why does ServerVariable[“REMOTE_ADDR”] returns the server IP?
  27. Reading XML with an “&” into C# XMLDocument Object
  28. Performance cost of a try/catch block [duplicate]
  29. Limit only one session per user in ASP.NET
  30. Web Service without adding a reference?

Leave a Comment