Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Why is DataSet slower than DataReader
What is the difference between “DataSet” and “DataReader” ?
✍: Guest
Following are the major differences between “DataSet” and “DataReader”
? “DataSet” is a disconnected architecture, while “DataReader” has live
connection while reading data. If we want to cache data and pass to a
different tier “DataSet” forms the best choice and it has decent XML support.
? When application needs to access data from more than one table “DataSet”
forms the best choice.
? If we need to move back while reading records, “datareader” does not support
this functionality.
? But one of the biggest drawbacks of DataSet is speed. As “DataSet” carry
considerable overhead because of relations, multiple tables etc speed is slower
than “DataReader”. Always try to use “DataReader” wherever possible, as
it’s meant specially for speed performance.
2007-10-24, 4741👍, 0💬
Popular Posts:
Managed Code and Unmanaged Code related ASP.NET - How do you hide Public .NET Classes and other publ...
What's wrong with this initialization? char *p = malloc(10); My compiler is complaining about an ``i...
What is shadowing ? When two elements in a program have same name, one of them can hide and shadow t...
What are the standard ways of parsing XML document? XML parser sits in between the XML document and ...
How To Download and install PSP Evaluation? - PSP Tutorials - Fading Images to Background Colors wit...