>>Please provide more details on the performance problem. I'd hate to rework my apps that use SET DELETED ON, and 10,000+ record tables are common.
>
>Easy to test.
>
>Use FoxPro Windows.
>1. Create a table having 100000+ records
>2. Create at least this tag INDEX ON DELETED() TAG DELETE
>3. SET DELETE ON
>4. BROWSE or SELECT * FROM table WHERE yourtagvalue INTO CURSOR TEMP
>You're gonna get the result right away.
>
>Now, do the same in Visual FoxPro 3 or 5. You'll end up with a wait time because of the SET DELETE ON which should not be use anymore.


Thank you for the info. I guess I'll guest try to keep the percentage of deleted records down, and not use that tag anymore.