Hi,

At June 3, 2003, 13:25, Robert DiFalco wrote:

> Is there any way to safely turn Forced Writes off when running Firebird
> 1.02 under Windows XP? I read somewhere that this was unsafe. Is XP
> anymore reliable in this area than NT was 4 years ago?

Yes, it is still true.

> Most of the text
> I have read about FW was written that long ago. Also, if it is not safe,
> is there a reliable way to repair the database if the worse should
> happen?

It always depends on the type of corruption. But, chances are that
you lost data and would have to pay someone to repair what you have
left.

> The speed difference is really pretty amazing and I would really like to
> keep Forced Writes off if at all possible.

You might want to have a look at Firebird 1.5 RC3. First of all, the
speed has increased dramatically, that you might not need Forced
Writes Off. But, if you still want Forced Writes Off, extra
configuration parameters has been added, so you can tweak when the
disk writes take place, and make sure you have a UPS that will
shutdown the server automatically.

> Finally, I couldn't find documentation on ibconfig for setting Forced
> Writes off, does anyone have any documentation?

It's done at the database level, not the engine level.

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