| Subject | Re: [firebird-support] Forces writes and transaction throughput? |
|---|---|
| Author | Michael Weissenbacher |
| Post date | 2008-12-03T11:58:04Z |
Hi Kjell!
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.
hth,
Michael
> But as far as I've understood, FB is being used in several places inWell, 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.
> 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)?
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.
hth,
Michael