>
>This was a really good technique in 2.6. But in VFP you don't know if the file returned by DBF() really exist on disk or is just in the memory. VFP doesn't guaranties the file really exist and my conclusion is (maybe wrong) that VFP writes the cursor to disk only when it doesn't have enough memory. (DBF() always returns a valid file name.)

This is from the VFP Help:

"Including NOFILTER can reduce query performance because a temporary table is created on disk. The temporary table is deleted from disk when the cursor is closed."

Without the NOFILTER clause, the assumption of VFP using memory for the cursor would seem to be true.