Information générale
Catégorie:
Codage, syntaxe et commandes
>>
>>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.
I know this. But there's a bug in VFP and NOFILTER doesn't force the file to be created on disk.
Vlad
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