Subject Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
Author Thomas Steinmaurer
>>> you are using a 4 Core CPU , with Multithreading , so it has 8 Virtual
>> cores
>>> 16% means that you are using 1 Core to the maxmimum
>>>
>>> Try running several Queries from different connections on classic server
>>> then you will use more cores
>>>
>>> Super Classic will Use 1 Core per Database , so that is all you get
>> for your setup
>>
>> Per Connection not per database.
>>
>>> Super Classic will only benefit you if you have several Databases
>>
>> You mean SuperServer here.
>>
>> Check out my FB 2.5 architecture comparison sheet:
>> http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf
>>
> Hi,
> You say that SS can utilize more CPU when connecting to diffren
> databases but
> Your comparison consider FB 2.5. Is this also true for FB 2.1 SS. As I
> remember setting CpuAffinityMask to more than 1 was not recommend
> earlier. Are firebird made some progress between FB 2.5 SS and FB 2.1 SS
> in this subject?

Yes. There is a difference between 2.5 SS and 2.1 SS. Also check out the
2.5 release notes p. 7ff.

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.