Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
SNIP>
Hi Jim,
>I just want to clarify something... I *assume* that the buffers you are referring to here are VFP internal buffers maintained in VFP storage and managed by VFP. Is that correct?
>
This is correct, I am referring to VFP internal buffers.
>If it is correct then I suspect that a low value for the REFRESH parameter(s) may have minimal actual performance consequence, on the basis that the OS is itself separately maintaining its cache and that changed CDX (or any other) records might well have been updated in the OS cache and so really come to VFP directly from there. Do you think this is aplicable?
>
I believe this is applicable, but there is no guaranty that the records to be read are kept in OS cash.
Also, the minimal supported value for SET REFRESH is 1 second, if your computer is fast enough, it is possible to significantly change index during half of this time.
Thanks,
Aleksey.
Précédent
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