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
On Thu, Jan 5, 2017 at 9:54 PM, trsk...@yahoo.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
> As you know, on a single connection, Firebird's cpu utilization calculate
> by 100% / no of cores.
>
That's not an arbitrary limit. Firebird is not capable of running a single
06.01.2017 3:54, trsk...@yahoo.com [firebird-support] wrote:
> please help me to point out which codes I should change & if my knowledge is
> enough is I
> only have basic C?
No way you or someone else can do this with current Firebird architecture,
sorry.
--
WBR, SD.
Hello all,
As you know, on a single connection, Firebird's cpu utilization calculate by
100% / no of cores.
On my 6 cores cpus, its only utilized 100% / 6 = 16%.
During database maintenance & testing (backup, restore, testing, etc) ,
sometimes, i feel it was to slow.
I want to change cpu