Re: [firebird-support] How to change cpu u tilization in Firebird engine?
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. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: Re[2]: [firebird-support] How to change cpu u tilization in Firebird engine?
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 operation, including queries can benefit from higher cpu performance. Regards, Anto
Re[2]: [firebird-support] How to change cpu utilization in Firebird engine?
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 [firebird-support] firebird-support@yahoogroups.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 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, >Anto. >
Re: [firebird-support] How to change cpu utilization in Firebird engine?
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, Anto.