VB6.Access97,ODBC,ADO too slow
We have been having some serious problems with the most recent version of
MDAC. Microsoft is aware of this problem and I would suggest staying away
from it.
Especially if you are using sqlServer 6.5.
David Ritchie
PetRock Technology, Inc.
171 Broadway
Saugus, MA 01906
(781)231-0500
www.PetRockTechnology.com
Quote:
> 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.
> cb
