Thanks guys for so quick replies!

Yes, I'm on Windows, I forgot to tell this before.

Is ForcedWrites Off by default? I couldn't find the answer from
firebird.conf.

I haven't modified firebird.conf, is it correct to assume it's good
enough for most uses like this?

Aivar



--- In firebird-support@yahoogroups.com, "Dan Wilson" <dwilson@d...>
wrote:

> On 6/1/2004 at 3:54 PM Steffen Heil wrote:
>
> > Hi
> >
> > > But then I noted that my database file was last modified

yesterday

> > although I had worked on it several hours today (creating stored
> > procedures.
> > I'm not sure if I made some data changes). Only when I

disconnected all

> > clients from database, the file mod. date got updated. Where were

the

> > updates stored until then, memory? some other file?.
> >
> > Don't fear.
> > I assume, you have your server running on windows?
> > This is by design. To reduce load, windows updates file meta

information

> > when closing the last open file handle to each file.
> > It is therefor common, that you file time get's updated only,

when the

> > server completely releases that file. Anyway, it writes

earlier... :D

> >
> > > If there were power failure, would my work have been lost, or

not?

> >
> > Not in this scenario.
> >
> > > Is there difference in this question between server and embedded
> > version?
> >
> > I can't tell for embedded, but since this is about windows file

handling,

> > it
> > should be the same.
> >
>
> I would like to add one comment to Steffen's fine comments: All

this assumes that you do indeed have forced-writes turned on in the
firebird configuration file. If you do not, all bets are off, and
your database is indeed vulnerable.

>
> Dan.