Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow/Strange behavior pulling data from MS Acess via ODB
Message
 
To
30/10/2006 17:50:34
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000
Network:
Novell 4.x
Database:
Jet/Access Engine
Miscellaneous
Thread ID:
01165601
Message ID:
01165664
Views:
18
>>Greetings -
>>
>>We're currently trying to pull ALL records from a MS ACCESS table via ODBC through a Remote View. The source table contains roughly 17000 records. When we execute the view, the record counter increments roughly 1000 records per second. Here's the part that's strange. When you start moving the mouse around while the query is running, the counter speeds up dramatically. When you stop moving the mouse, it slows back down to a sluggish pace. This happens both over a network and a local drive.
>
>Does the problem persist if you open the view from the Command window?

Hi Al, Yes - it also happens when you run the view from the command window.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform