>>>> Hi, I've upgraded to FB2 on linux a week ago.
>>>>
>>>> In this version I can turn off the forced writes setting, but it comes
>>>> back again after a few minutes. I'm using the gfix and gstat commands
>>>> to set and observe it. Any ideas?
>>> Actually, in Firebird 2.0.x, Forced Writes doesn't work, anyway (fixed in Fb 2.1). So, whatever is being written to or read from the database header of a Fb 1.5 or Fb 2.0 database, there aint no Forced Writes. ;-)
>> Sounds dangerous, weird or whatever. ;-)
>>
>> Can you elaborate on what "there aint no Forced Writes" mean?
>>
>> - Is it currently a useless setting?
>
> Yes. A no-op.
>
>> - Particular to Linux or Windows as well?
>
> Not Windows. Linux; other POSIX not known so far. It's been a registered Linux kernel bug for more than 2 years, if you knew what you were looking for.
>
>> - Since when is this a "known issue" (if at all)?
>
> Very recent - the result of Alex's curiosity about why FW ON was just as fast as FW OFF on his test system. Hence why you see that it's fixed in Fb 2.1 RC 1 but not in Beta 2. :-) You can read the forensics in the latest release notes:
> http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-global-fwrites

Thanks!

A number one reason then, why people often report that their Firebird
installation is faster on Linux than on Windows, even with forced writes
= ON on both platforms. ;-)



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com