Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is SCAN to be avoided?
Message
De
10/11/1999 10:43:17
Walter Meester
HoogkarspelPays-Bas
 
 
À
10/11/1999 09:54:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00289152
Message ID:
00289597
Vues:
28
Srdjan,

>good thing to do is to have dummy index
>tag on 'deleted()' which if active, dramatically improves performance on menu
>operations like scan/endscan ,append from,replace all etc.

No this is not. It's an common mistake that the index on deleted() improves performance dramaticly. If there are not many delete records you can only degrade performce with these commands.

Especially when we talk about the append command, VFP has to update the index each time when a record is added, dramaticly slowing performance.

Only benefit of the DELETED() tag can be in tables where huge amounts of deleted records exists and it's not possible to get rid of them in a ellegant way.

Walter,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform