Re[2]: [firebird-support] How to change cpu utilization in Firebird engine?

2017-01-07 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
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

Re: [firebird-support] How to change cpu utilization in Firebird engine?

2017-01-07 Thread trsk...@yahoo.com [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

Re: [firebird-support] How to change cpu utilization in Firebird engine?

2017-01-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
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

Re: [firebird-support] How to change cpu utilization in Firebird engine?

2017-01-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

[firebird-support] How to change cpu utilization in Firebird engine?

2017-01-05 Thread trsk...@yahoo.com [firebird-support]
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