>>>In a Web environment, I have 4 VFP servers running to process the incoming requests. I have found that occasionnaly, one save by a VFP server is not reflected immediately on another VFP server. What I mean by that is that it may takes up to two seconds before the other servers can read the updated data from the tables.
>>>
>>>It seems that I have to force a flush here.
>>>
>>>What would be the best approach to make sure all data is saved on disk immediately after the VFP server that did the save transaction?
>>
>>FLUSH force buffers to save, it is recommended to use it after transaction that contain new records into VFP tables. SYS(1104) might help also, but usually to assure buffers contain the latest information. Maybe data for another server buffered for certain time so it des not see changes for 2 seconds using cached information. Try SYS(1104) to refresh buffers immediately without waiting for SET REFRESH settings work.
>>This also could be a network caching issue, but I do not know exactly.
>
>Ok, here is the result.
>
>FLUSH doesn't do the job.
>
>SYS(1104) does it and it's overall to whatever change was done at any table.

Good to know that! But I would recommend to use FLUSH anyway after each transaction for reliable updating of table headers when new records inserted. This recommendation is from Hacker's Guide.