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:
> 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

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