Comments below:

> Let's clarify, then, does the problem happen to you ONLY if forced writes is
> > turned off?
>
>Simple answer - yes.
>
>Complex answer - Once ForcedWrites is off, then windows goes
>into very lazy write mode - it doesn't bother to write at
>all. The only way to ensure that the data is saved to disk
>is close the connection and re-open it.
>
>So what we need to find out is if there is ANY way of
>getting windows to save its data in this mode so that it's
>at least safer. Personally I've been living with the
>performance hit, and we have been changing the servers to
>Linux when practical, but there must be something we can do?

I've just done some research on MSDN's website and found a function that
flushes a file from memory to disk. The function is
"FlushFileBuffers". It's usage is described on MSDN. It needs a file
handle like when using WriteLn and Write to write information to a file. I
don't know the inner workings of Firebird in this area, but if it does use
this principal to write the information to the GDB file, then this function
should do the trick, but when to call it is to be discussed accordingly and
how to implement it, by the persons responsible of this part of the
development.

This is just my 2 cents.

Have a nice day.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)