Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very long time delay while accessing big tables with ADO
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00405817
Message ID:
00405859
Views:
23
Donald;

Just let me say you are not using FoxPro's Data Engine. You are using ADO via ODBC, which is very slow compared to native VFP. Remember VB does not have a data engine built in. VFP is data centric so it can use Rushmore Technology to it's full advantage.

I presume you are running the process through a FOR Loop. You might be at the technical limit of the ADO ODBC technology.

Hope someone has a good answer. Wish you the best...

Tom
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform