>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.
Michel:
Why should we not use SET DELETED ON? The on-line help for VFP 3.0 and 5.0 says "Queries that use DELETED() to test the status of records can be optimized ... if the table is indexed on DELETED()." I ran some test queries, and yes, now there's a slight delay -- but still it's enormously faster with the DELETED() tag than without it.
What am I missing?
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