VB6,Access97,ODBC,ADO too slow 
Author Message
 VB6,Access97,ODBC,ADO too slow

I have an app that unzips files from a CD, parses the resulting text
files into virtual recordsets and recordsets attached to Access97
tables, then does some slicing and dicing and then mixing and matching
of the data.  The records number into the millions.  I'm using an ADO
connection and recordsets as well as ODBC.  The code works perfectly
through all the steps.  The problem is, it runs incredibly slow.  Any
suggestions for optimization would be greatly appreciated.  I'm
currently looking at Disconnected Recordsets, and incorporating ADO
Command objects for executing repetitive action queries.  Any comments
on the efficiency of these techniques?  Thanks in advance.

Mon, 22 Jul 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. VB6.Access97,ODBC,ADO too slow

2. Slow, slow, slow search on VB6, ADO and SS7

3. VB6 odbc access97

4. ADO VB6 Access97 Unable to run Access Query -2147217900

5. VB6,Access97,ADO - Update query doesn't update all records

6. VB6/ADO/Access97 Security

7. ADO VB6 Access97 Unable to run Access Query -2147217900

8. Seek method, Access97 database, ADO in VB6

9. VB6 ADO Access97 and data environments

10. Problem with Filter and Requery, VB6, ADO 2.0, Access97, Win95/98

11. ADO VB6 Access97 Unable to run Access Query -2147217900

12. MSDE VB6 ADO - search on recordset very slow.


Powered by phpBB® Forum Software