>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?
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