Subject Re: [firebird-support] force write question
Author Paul Vinkenoog
Hello Michele,

> I've a firebird server 2.1.1 on a Windows 2003 server with HP smart
> array E200i (with write cache false).
> Database "force write" is active.
>
> If I go on my database's folder i detect "modify access" is older than
> last database commit.
>
> Why "modify access" is old?

When a file is kept open, Windows often (in my experience) leaves the
"last modified" timestamp at the previous value. Once all connections
to the database are closed, the server releases the file and the timestamp
is updated.

This used to freak me out quite a bit, but I've learned to live with it :-)

> With "force write true", firebird would not have to write instantly?

It does. But the timestamp in the Windows Explorer doesn't show it.


HTH,
Paul Vinkenoog