Hi,

At March 24, 2017, 5:22 AM, Doychin Bondzhev doychin@... [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)