Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Browse large tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-18 : 22:04:02
andrea writes "Which is the best way to browse a large table (> 1M records) with ado, vb6 and a datagrid control.
i try to use the asyncfetchnonblocking option to run my program without wait for the complet fetch of the client recordset, but vb6 wait for 25sec before show the main form
Using delphi+ado (but this is only for a test) the main form appear immediately toghether with the backgrounf fetching thread. WHY vb6 has not the same behaviour??

i use a client recordset, with OpenStatic and LockOptimistic option

If thi is not the right forum, please can you give some URL to seach for tips."
   

- Advertisement -