Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 2066 (undocumented) Index File xxx is corrupted...
Message
From
19/07/2003 19:02:13
 
 
To
19/07/2003 14:15:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00810798
Message ID:
00811808
Views:
41
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform