Hi Jon,
While I feel that an index on DELETED() **did** help performance in FPD, it is quite clear that it is no longer the case in VFP, most especially if only a small percentage of the records are deleted (or none, as is often the case).
If you want a simple way to test this, find a table with lots of records but few/none deleted. Then run your SELECT and time it.
Now delete the TAG for DELETED() on that table and REBOOT.
Once back up, run the same test and time it.
good luck
>Hi Walter,
>
>I have always used the DELETED() index and only once has it caused me a perfoamnce issue. In my opinion (and its just my opinion) its best to set them up but if you do find your are having performance issues then it would be one of the first things I would look at removing.
>
>To be honest I have never had enough time to do any sort of benchmarking with DELTED() set and not set, so maybe I dont have the authority to make any general remarks over it. All I can say is that in my experience it hasnt caused major every day performance problems just occasional exceptions.
>
>Jon
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