RE: {Disarmed} [firebird-support] Hint for maximaze FB performance, CPU Utilization - again.
> Each connection does get an single OS-thread only which can use no more > than an single core at the same time. On an 6-core CPU this means an > maximum of 16% utilization for total CPU. That is true for pre-v3.x SuperServer builds, not true for v3+ Not, was never, true for Classic or SuperClassic builds... > Firebird does not spread an single query onto several cores as e.g. > Oracle can do. True for all builds. Firebird does not, yet (it is a feature request), support query parallelization. Sean
Re: {Disarmed} [firebird-support] Hint for maximaze FB performance, CPU Utilization - again.
> During my development - only single connection to FB Server, I do a > lots of query. Each query took about 25-30 secs to complete, but CPU > Utilization only used at around 16% on my six cores computer. > On Ryzen 7 with 16 threads, I believe CPU utilization for FB is only 6%. > > Are there any hints to set Firebird to use more cpu's power? Each connection does get an single OS-thread only which can use no more than an single core at the same time. On an 6-core CPU this means an maximum of 16% utilization for total CPU. Firebird does not spread an single query onto several cores as e.g. Oracle can do.
[firebird-support] Hint for maximaze FB performance, CPU Utilization - again.
Hi guys, I am using FB 3.02 in Superserver mode. During my development - only single connection to FB Server, I do a lots of query. Each query took about 25-30 secs to complete, but CPU Utilization only used at around 16% on my six cores computer. On Ryzen 7 with 16 threads, I believe CPU utilization for FB is only 6%. Are there any hints to set Firebird to use more cpu's power? I think FB distributed works load based on number of cores. Each load divided equally on cores. So if there are 4 cores, each load/connection gets 1/4 cpu utilization. It will great if FB can distribute work load based on connection, first connection gets 100% cpu utilization, second connection, each one, get 50% cpu utilization, so on. Btw, on SuperClassic FB 2.5 & no of connection +/- 100, I rarely saw cpu utilization raised up to 90% during heavy process. Mostly it was aroung 50-60% CPU Utilization. Thanks & regards, Anto