Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP9 Slower than VFP8 in SQL SELECT
Message
De
01/02/2011 18:04:43
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01498230
Message ID:
01498235
Vues:
104
Make sure the table and indeces are all using the same code page.

>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform