Subject Re: [firebird-support] Forces writes and transaction throughput?
Author Milan Babuskov
Leyne, Sean wrote:
>> I've been running with forced writes off on Linux and never had
> database
>> corruption - YMMV.
> A very lucky man, but luck has a way of running out when you least
> expect or want.
> Think of it this way:
> If I gave you a gun which had 1 million cylinders loaded with one
> bullet; would you want to play "Russian roulette"?

Heh, he's got more chance of being hit by a lightning than finding the
bullet :)

So, maybe a gun with 1000 cylinders could be a better comparison - if
there weren't for 'ordered writes'. If you use a filesystem with ordered
writes (ext3, reiserfs since kernel 2.6.9, etc.), chances of corrupt
database are really low. You can lose some committed transactions, but
you won't get corrupt db file.

Milan Babuskov