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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only