Subject Re: [firebird-support] Forces writes and transaction throughput?
Author Michael Weissenbacher
Hi Kjell!
> But as far as I've understood, FB is being used in several places in
> systems with thousands of users. Is this thousands of SIMULTANEOUS
> users? In that case, how do you configure FB to handle a high
> transaction/commit rate without this "motorcycle" effect (thrashing disk
> head)?
Well, for big imports i tend to disable forced writes to speed them up. Also i don't think it's a big problem to disable forced writes on a proper Unix/Linux server with a battery backed RAID and a proper UPS to prevent accidental power loss. But beware to do this on Windows, IIRC it's deadly to disable forced writes there.

I've been running with forced writes off on Linux and never had database corruption - YMMV. Please note that real forced writes support wasn't availalbe on Linux anyway until very recently. I can't remember when they fixed it, but it was after the release of 2.0.