Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why is the fields() method of the rs in ADO soo sllllooowww?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Titre:
Why is the fields() method of the rs in ADO soo sllllooowww?
Divers
Thread ID:
00185464
Message ID:
00185464
Vues:
64
Hi,

I connect static, locktype= 4 (unidentified, but it works, courtesy JVP I think) to 10k table in a 100 Mb access db.
The access is reasonable, considering ..., but when I go and extract the data into vfp variable using the Recordsets' fields() methods, it takes for ages.

The time that consumes is proportional to the number of times I execute the method. It does not go back to the server when it does that does it, like when you REPLACE fields :).

TIA,

Marc

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Répondre
Fil
Voir

Click here to load this message in the networking platform