07.01.2017 12:06, trsk...@yahoo.com [firebird-support] wrote:
> If cpu utilization can be set, perhaps, all operation, including queries can
> benefit from
> higher cpu performance.
It is not given at all. Inter-thread synchronization has its price.
--
WBR, SD.
Not related to queries, like I said before, it was for maintenance such as
backup / restore, delete, insert,etc.
From those operations, I noticed that Firebird 3.0 SS didn't use 100% cpu
utilization. For queries, i guest, the behavior will be same
If cpu utilization can be set, perhaps, all
Hi,
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.
--
Regards,
Alexey Kovyazin
IBSurgeon суббота, 07 января 2017г., 11:26 +03:00 от trsk...@yahoo.com
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