Re: ADO.NET performance with large tables

ADO.NET works with disconnected rowsets. A rowset need not (should not) be
comprised of all of the rows of a table. It should contain the rows you are
seeking--the answer to the query and no more.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Nico Callewaert" <NicoCallewaert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:BDB5E02D-A2C1-4D60-987D-F3D8F53D033C@xxxxxxxxxxxxxxxx
> Hi list,
>
> ADO.NET works with disconnected data I guess ?
> So, the entire table has to be loaded. Let's say a large company has a
> huge
> customer table. Loading every time that entire table seems like a
> performance drop to me, or am I missing something ?
>
> Many thanks in advance,
>
> Nico Callewaert


.