ADO.NET performance with large tables

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
.

Relevant Pages

  • Re: OT - removal of CoolWebSearch
    ... Was hoping I'd have some way via RDP but had an inkling I was wishing for ... another trip to a customer who feeds and waters well so not all ... > reboot in safe mode, ... > Windows boots and remove things that could be loading it. ...
    (microsoft.public.windows.server.sbs)
  • Re: Object design question
    ... care of loading them? ... the ApplicationController would load the Customers only. ... the Customer also has related Orders. ...
    (microsoft.public.dotnet.languages.csharp)
  • Planed Work Hours by customer
    ... I added a Custom field and I am loading it in each task. ... I need to get a report where I can show the planned work hours for a specific month grouped by Customer. ...
    (microsoft.public.project.pro_and_server)