Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
WAN and Visual FoxPro Database (Data Accessing speed)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00276225
Message ID:
00276304
Vues:
35
Dan,

That key on Deleted() is no longer a good idea at all. It will almost surely HURT performance of a VFP application!

Some say that it has always been this way, suggesting that we were all misinformed when this "tip" originally made the rounds. I happen to disagree with that opinion, but have no way to prove it one way or the other. Just to be clear, I have NO DOUBT that an INDEX on Deleted() will most likely HURT an app.; I doubt that it has always been this way.

Cheers,

Jim N



>Make sure the program is installed and running from the local machines.
>Make sure you're useing buffering. Make sure you're views are optimized sys(3054). Make sure you have a key on Deleted() on all your tables.
>
>You can also use coverage logging in the Debugger or just step through the program yourself to see which lines are so slow.
>
>HTH
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform