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?