Subject Re[2]: [firebird-support] How to change cpu u tilization in Firebird engine?
Author Alexey Kovyazin (ak)


There is no sense to tune or upgrade CPU or other hardware without prior analysis of slowness reasons.

In 95% the reason is in non-optimal queries plans or absense of indices.

Alexey Kovyazin

суббота, 07 января 2017г., 11:26 +03:00 от trskopo@... [firebird-support]


Thanks for your clarification.

I was planning to upgrade my cpu with a used Xeon 2683 V3 (price on my country is about the same with I7 6700K), but it has 14 cores & 35MB L3 cache.

So, I guess, a single connection in Firebird 3.0 will running poorly on Xeon 2683 V3, it will only utilized about 7% cpu. I have to re evaluate again this plan.

Btw, if there are 6 connection on 4 cores, how is cpu utilization calculate?

Thanks & regards,