Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Codage, syntaxe et commandes
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
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