Re: Accessing A Large MS SQL Table Over ADO Components

From: Bill Todd (no_at_no.com)
Date: 10/11/04 

Date: 11 Oct 2004 11:02:08 -0700

The best way is not to do that at all. No user wants to scroll through
500,000 records. You should let the user enter some search criteria
that will select no more two hundred records to view and work with in
the grid. See http://community.borland.com/article/0,1410,28160,00.html
for a more complete explanation. 

-- 
Bill (TeamB)
TeamB cannot answer questions received via email

Relevant Pages

  • Re: NewsGroups vs vBulletin forum
    ... Craig Stuntz [TeamB] wrote: ... Hint: The "about" results are wildly off the mark, ... you scroll to the end of the result sets. ...
    (borland.public.delphi.non-technical)
  • Re: Does anyone use .NET applications?
    ... Nick Hodges [TeamB] wrote: ... > listbox for longer lists. ... Depending on the length of the list, you may still need to scroll to ...
    (borland.public.delphi.non-technical)
  • Re: Ping Liz re your Delphi Sudoko app on your site
    ... Remy Lebeau (TeamB) wrote: ... the form's client area, so I have to scroll to see the last row and ...
    (borland.public.delphi.non-technical)
  • Re: Delphi 9 - Your Expectations
    ... Rudy Velthuis [TeamB] wrote: ... plus you can scroll with the mouse wheel ...
    (borland.public.delphi.non-technical)
  • search datagrid control client-side
    ... Is there a way to scroll a datagrid to a certain row based on search criteria ... I'm not asking how to filter a dataset or alter a select statement, ...
    (microsoft.public.dotnet.framework.windowsforms.controls)