Subject Re: [firebird-support] SuperServer on SMP Machine
Author Helen Borrie
At 10:13 AM 9/02/2005 +1100, you wrote:

>Hi,
>
>I notice that Helen in a previous post said: "Classic just *also* happens to
>be useful on SMP machines because it doesn't misbehave with multiple cpus as
>Superserver does."
>
>We have developed and application which makes use of the Firebird Super
>server 1.5.1 It has been deployed on a Win2000 Server, which happens to be a
>SMP Machine.
>
>Could someone elaborate on the possible problems of issues regarding the use
>of this version of the FB engine on a SMP machine, or otherwise point me on
>the right direction to collect documents which may state these problems
>please.

On Windows, for Superserver, this parameter needs to be set so that the
entire service runs on one CPU. If it is set for multiple CPUs, you get
the "see-saw" effect, where Windows will swing the entire process from one
CPU to the other when CPU usage reaches capacity on one CPU.

It shouldn't be a problem for you if you didn't fiddle with the default
cpu_affinity parameter in firebird.conf, which is configured to the first
processor.

./hb