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
http://www.flamerobin.org
http://www.guacosoft.com