|Subject||Re: [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.
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,