Re: [firebird-support] Ryzen R7 vs Kaby Lake 7700K, which one to choose?

[Daniel Rail dan...@accra.ca [firebird-support]]

Hi,

At March 24, 2017, 5:22 AM, Doychin Bondzhev doyc...@dsoft-bg.com 
[firebird-support] wrote:

> Hi,

> I just got my last piece (the motherboard) for my new Ryzen system. I'll
> install all the software during the next few days and will write back 
> here about my experience with FB.

> I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the
> storage (RAID 10 with 6 HDD) so I expect there will be very decent speed
> up for FB.

> At least my personal experience shows that for well written code the 
> biggest problem is the database storage.

> For classic or super classic you will get better results with Ryzen when
> you have multiple clients accessing your database then with KL.

The same can be said with Firebrid 3.0 SuperServer.

> KL is good for super server or for small number of clients where higher
> IPC will help you to process queries faster.

For Firebird SuperServer versions prior to version 3.0, I can see
KabyLake being better. But with Firebird 3.0, SuperServer is truly SMP
compliant, and will use more CPU cores compared to before (but this
still depends on the scenario, as an example: only one application
connecting with only one connection will most likely use the same
number of cores when comparing between version 2.5 and 3.0).

> but all this is irrelevant if you have slow storage.

This is mostly the problem that we face with customers when they
complain that our application is slow.

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

Re: [firebird-support] Ryzen R7 vs Kaby Lake 7700K, which one to choose?

[Doychin Bondzhev doyc...@dsoft-bg.com [firebird-support]]

Hi,

I just got my last piece (the motherboard) for my new Ryzen system. I'll 
install all the software during the next few days and will write back 
here about my experience with FB.

I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the 
storage (RAID 10 with 6 HDD) so I expect there will be very decent speed 
up for FB.

At least my personal experience shows that for well written code the 
biggest problem is the database storage.

For classic or super classic you will get better results with Ryzen when 
you have multiple clients accessing your database then with KL.

KL is good for super server or for small number of clients where higher 
IPC will help you to process queries faster.

but all this is irrelevant if you have slow storage.

Doychin

On 23.3.2017 ã. 05:00 ÷., trsk...@yahoo.com [firebird-support] wrote:
>
>
> Hi all,
>
> I am considering to upgrade my development cpu.
>
> Between Ryzen & KL, although Ryzen is very good at multi threaded
> processing, I guest, for Firebird, KL will be faster.
>
> For development, mostly I used only single connection to FB, and since
> FB distributed workload among cores, for a single connection, total
> utilization for all cores is the same as 100% utilisation for 1 core,
> and for 1 core operation, KL is more superior than Ryzen.
>
> Can anyone confirm this? Or has anyone here have a Ryzen and care to
> share the experience using Ryzen with FB?
>
> Thanks & regards,
> Anto
>
>
> 


-- 
Doychin Bondzhev
dSoft-Bulgaria Ltd.
PowerPro - billing & provisioning solution for Service providers
PowerStor - Warehouse & POS
http://www.dsoft-bg.com/
Mobile: +359888243116


[Non-text portions of this message have been removed]







++

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/

[firebird-support] Ryzen R7 vs Kaby Lake 7700K, which one to choose?

[trsk...@yahoo.com [firebird-support]]

Hi all,

I am considering to upgrade my development cpu. 

Between Ryzen & KL, although Ryzen is very good at multi threaded processing, I 
guest, for Firebird, KL will be faster.

For development, mostly I used only single connection to FB, and since FB 
distributed workload among cores, for a single connection, total utilization 
for all cores is the same as 100% utilisation for 1 core, and for 1 core 
operation, KL is more superior than Ryzen.

Can anyone confirm this? Or has anyone here have a Ryzen and care to share the 
experience using Ryzen with FB?

Thanks & regards,
Anto