Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow/Strange behavior pulling data from MS Acess via ODBC
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Slow/Strange behavior pulling data from MS Acess via ODBC
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000
Network:
Novell 4.x
Database:
Jet/Access Engine
Divers
Thread ID:
01165601
Message ID:
01165601
Vues:
49
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.

Any insights into this behavior?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform