Reading a large number of records

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

Could someone please provide a code example of how to read records from an
access table into a grid, the fastest possible way, for read-only view?

Thanks

Regards
 
John:

A datareader is the fastest way to do it currently.. if you are using
ASP.nET you can set the grid's datasource = yourCommand.ExecuteReader();

If you are on the desktop, just go ahead and bind to a datatable. It won't
be as fast as using a reader per se, but if you use a reader you are just
going to have to build a datatable or some other IList implementing object
that you can bind to anyway.

HTH,

Bill
 
Could someone please provide a code example of how to read records from an
access table into a grid, the fastest possible way, for read-only view?
Click to expand...

Well, basically, the idea of "reading a *LARGE* number of records" is
a bad one to begin with - no matter whether you can make it fast, or
not. Mind you - your user will always have to scroll or select from a
large set of data - anything beyond a few hundred just becomes
unmanageable.....

Reconsider your design - you should never even have the urge to
display huge numbers of records in the first place.....

Just my 2 cents.....

Marc
 
Paginating is the best way to consider, just opinion
Using stored procedure with databinding along with page params ^^
 
Paginating is the best way to consider, just opinion.

No, paginating is one way to deal with the symptoms, but really, the
design of the app avoid very large data sets in the first place.

Marc
 
Back
Top