data loss vs flush (was: TIP, how to fight with corrupted indexing)

[Robert Brenstein]

>  >
>>  Ruslan, I Flush after each database change but I definitely had data
>>  loss on a few ocassions (yes, data was entered into db but was not
>>  there after crash). I recon that Flush cleans the caches of Valentina
>>  but the operating system has its own write cache that may prevent the
>>  data to be actually written to disk before the crash.
>
>No, Flush() at first write from Valentina cache,
>Then calls system flush() to force data be written on disk.
>

Hmm, if so, then how is it possible that I lost data? I do not 
imagine that. My program writes a log of all transactions, so I could 
verify that user indeed did data entry and it was processed properly 
but the data was NOT in the database after the server restart. Last 
several transactions before each crash seem to be always lost.

Robert