Re: ADO vs. Progress Bar


"Hatim Arqam" <Hatim Arqam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:71EC4D58-2923-4020-B770-3A2863B4236B@xxxxxxxxxxxxxxxx
> How can I monitor (by a progress bar or whatever) the data retrieved from
a
> select statement sent to a sql server 2000 DataBase by ADO control from a
VB6
> form?

Is it using an ADO object like a Recordset?
If so, you want the FetchProgress event.
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdevtfetchprogress.asp

> Making in consederation that the targeted table is very huge ... about 3
> millions of rows.

Well I would not do that. It would have appalling performance.
Nobody can browse 3 million rows.
And what if was 100 million records?

When users say "show me this table", they dont really mean that.
Just show them a portion of the table.

So you should work to retrieve, say 2000 rows and present that
(using WHERE clauses or TOP (of SQL Server)).
If the user moves down to the end of the first 2000, then SELECT the next
1000, lose the first 1000 and keep the second 1000 and reposition.

And if the user presses a key that means go to the bottom, you SELECT the
last 2000 rows.

You will get much better perceived performance.

Stephen Howe



.

Relevant Pages

  • Re: Cross Database Join, C++ program set up confusion
    ... Well what kind of data are you returning if it is not in Recordset? ... Recordset is returned (it is fractionally faster as ADO does not waste time ... If the default database is db1 on the ... It is a function of SQL Server. ...
    (microsoft.public.vc.database)
  • Re: Full-Text Results to MS Access
    ... Being new to SQL Server and ADO, ... (My database was started in pre-ADO days so the Access ... like a true/false flag, a value, etc., but if the result is a recordset, I ... based on some full-text search criteria. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Implementation of full text
    ... There is no documented way of accessing the MSSearch catalogs directly other ... tables in SQL Server to identify the row the hit occurs in. ... table to a client from an extended stored procedure. ... To use the recordset returned from the ESP as a virtual table>. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Upsizing issue
    ... >>> half the application because of stupid Recordset problem. ... You could link the SQL Server ... magnitude as modifying the original ASP pages. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Display data from ODBC table
    ... Have you tested updating the data in the DatasheetView of the Query? ... If you can in the above, you might have set the Recordset Type of the Form ... If you can't update in the DatasheetView then the problem is in the Query. ... Check your permissions on the SQL Server. ...
    (microsoft.public.access.forms)