>The FLUSH command simply writes data from VFP's cache memory to the network card. If caching is done after that by the NIC, drive controller, etc, FLUSH has no effect on that.
>
Craig,
Add to that, recent NIC's have a Power Saving Mode, which I found to be enabled by default on my Realtek NIC. So if the Power management side of the Computer hosting the data files is doing its thing, OOPS - Data Loss - Index Corruption - Perhaps. I would think that whatever computer is hosting the data files, whether it is called a server or not, should have all the power management features checked OFF. And the Write Caching OFF.
Regards
>>Hi,
>>Why last few records (newly added before ssytem crash) still could be lost even I have FLUSH after END TRANSACTION in every transaction?
>>
>>Thank you