At 10:37 AM 6/15/2004, Elmar Haneke wrote:

> > Databases in general are very vulnerable to data write order. Data must be
> > stored on the hard drive in the right order.
>
>For the database it should be sufficient to rely on the fact that
>every data is written to the right position and reading back the data
>does give that what was written there last time. It does not matter at
>what time the transfer from write cache to disk does take place (this
>is initiated by the OS and invisivble to the DB-server).

That is true of databases that rely on journalling for crash recovery.
With Firebird, the order of writes is what gives us instant crash
recovery. As long as the system never crashes, there's no problem.
One power failure and there's your problem.

Regards,


Ann