Subject | Re: Fw: [ib-support] Disconnecting takes very long |
---|---|
Author | Doug Chamberlin |
Post date | 2002-02-23T00:31:49Z |
At 02/22/2002 07:16 PM (Friday), Artur Anjos wrote:
regarding this forced writes setting, why would anyone want to operate a
Firebird database with forced writes OFF? In fact shouldn't we just remove
the option altogether?
I see no good reason for forced writes being off except possibly the odd
time when lightning fast performance is more important than ensuring
database integrity. However, I think those times are rare. Given today's
hardware speeds and capacities does the need to turn off forced writes ever
really come up? Does anyone have real, measured data on the difference it
makes?
>Careful write is present in all cases, though without forced write, it'sGiven the above, and given the support questions which arise regularly
>careful only up to the Operating System file cache. Forced write has no
>effect on Windows 3.1, Windows 95 and Windows 98. On Unix and NT, it causes
>the operating system to bypass its file cache and send the page directly to
>disk.
regarding this forced writes setting, why would anyone want to operate a
Firebird database with forced writes OFF? In fact shouldn't we just remove
the option altogether?
I see no good reason for forced writes being off except possibly the odd
time when lightning fast performance is more important than ensuring
database integrity. However, I think those times are rare. Given today's
hardware speeds and capacities does the need to turn off forced writes ever
really come up? Does anyone have real, measured data on the difference it
makes?