Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
VFP9 Slower than VFP8 in SQL SELECT
Versions des environnements
I finally upgraded my development to VFP9 SP2 from VFP8. Added in lots of coding to take advantage of new reporting features, etc. All worked well on my fast single machine.
But when put on a network with multiple users, the data retrieval was 3-5 times as slow or 20% of the previous speed.
I've built a small program that just does one select statement from a 100,000 record database - VFP8 - perhaps 1/2 second as expected. VFP9 - 5 seconds.
What could I be doing wrong?
Thanks,
Jim Condon
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement