>>Oh, I see. Should closing the file (as we did, in the tests) flush the Windows cache?
>
>No it doesn't
>
>> And, is there a way to disable the Windows cache? Or is FLUSH FORCE the only option here?
>
>There's Win API that allows to flush Windows buffers FlushFileBuffers
http://msdn2.microsoft.com/en-us/library/aa364439.aspxWould a select * from table help ? Because Select always reads from disk . I.e. If the data is there in the select cursor then The data must be present on disk ....