> One of our customers brought something to our attention the other day that I
> can't explain. He was looking at the "File Modified" time of his database
> file and noticed that the Windows "File Modified" time really didn't
> correspond to anything. The screenscrape he sent to us Monday afternoon
> showed the last modified date as around 1000 hrs on the previous Friday.
> People were in and out of the database all day, so writes would have been
> occurring up until at least 1800 Friday evening (in addition to Monday
> morning).
>
> I've looked at the documentation for IB, and have not found anything that
> tells me when the OS level "File Modified" stamp is changed.
>
> Anyone here know?

One reason might be that FORCED WRITES is OFF, so changed data pages
are buffered and are in the hand of the operating system to flush
them onto the disk, when the OS has nothing other to do. It was
shown that under Windows this can be very dangerous due to a
Windows bug (?), where data pages aren't flushed at all, except
when the InterBaser server is shutdown properly.

As you may see, in case of a power failure ... ;-)


HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com