Subject RE: [firebird-support] Speed up Firebird
Author Thomas Steinmaurer
> Cristiano,
> As you are using W2k and are stuck with FB1.0.x:
> FB 1.0.x struggles on multi cpu machines, and it is best to set the
> CPU_AFFINITY to one cpu only.
> Upgrade to FB1.5.x and you get much better mutli cpu ability, but more
> importantly, classic server which scales better on multi cpu machines.
> use "gfix -w async ...." to set the sweep interval to 0 so that sweep is
> never run,

you don't deactivate an automatic sweep with "gfix -w async".
You will turn FORCED WRITES OFF, and doing that under Windows,
you will ask for troubles. ;-)


Best Regards,
Thomas Steinmaurer

Logging/Auditing Suites for InterBase, Firebird and Advantage Database Server
http://www.iblogmanager.com
http://www.adslogmanager.com