Subject Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)
Author Helen Borrie
>Helen Borrie helebor@... [firebird-support] wrote:
>> At 12:59 p.m. 30/10/2014, Geoff Worboys
>> geoff@... [firebird-support] wrote:
>>>Is it safe to assume that, when you were running SuperServer,
>>>you had edited firebird.conf to change the installation default
>>>CpuAffinityMask from 1 to 15 ? (So that it would use all 4 of
>>>your processors.)
>> That wouldn't make any difference unless the same Fb server was
>> serving multiple databases. Fb 2.5.3 SS doesn't use multiple
>> CPUs otherwise...

At 02:36 p.m. 30/10/2014, Geoff Worboys geoff@... [firebird-support] wrote:

>Doesn't that depend on how they implemented the separate threads?
>SS does/can use different threads for separate connections to the
>same database, can't it? So if the threads operate over separate
>connections then wouldn't SS be able to use multiple CPUs?

Not in 2.5 (Dmitry will correct me if I'm wrong, I hope!), but I'm fairly sure it's a Yes in Fb 3. AFAIR, in 2.5, multiple CPUs will be used for connections to multiple databases if they are available. We're talking here about SS. SC behaves the way you describe, as far as I understand.

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"