Hi Paul,

Is the possible unreliability on Windows only applicable in
these cases (power loss/abnormal windows shutdown/freeze)?

In that case async mode is acceptable, because we run a UPS.

Best regards,
Maarten

On Fri, Dec 3, 2010 at 11:25 PM, Paul Vinkenoog <paul@...> wrote:

>
>
> Maarten Klerk wrote:
>
> > We found a possible solution for the problem. We changed Firebird to
> > work in async mode. Now it is very rapid (again). Does anyone know
> > the impact of this change? We have read about this setting to be
> > unreliable on Windows system.
>
> In the case of a sudden power loss, an abnormal Windows shutdown or a
> freeze-up, you risk database corruption. Mind you, on Linux too you
> should leave forced writes on under most circumstances.
>
> It would be interesting to know if your SQL Server runs in async mode.
> That would explain the performance difference, but it would also mean
> that SQL Server is run in an insecure manner here.
>
> Cheers,
> Paul Vinkenoog
>
>
>


[Non-text portions of this message have been removed]