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