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 22:57:08
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:
01165973
Views:
16
Thanks for all your help Al. John Ryan's suggestion seems to have solved the issue.

>>>>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.
>
>It might be time to go into Task Manager and take a look at the processes that are running in the background. Take a look at CPU utilization before you start to load the view, and while it's running.
>
>For example, some antivirus programs can be set to scan your hard drive at a specific time of day, but scan in the background i.e. only when the system isn't "busy". In a case like this the AV scanner might think a moving mouse means the system is "busy" (so it suspends scanning), while no mouse movement means it's "idle" (so scanning resumes).
Previous
Reply
Map
View

Click here to load this message in the networking platform