Subject Re: [firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits
Author Mark Rotteveel
On 19-5-2018 15:00, fabianch@... [firebird-support] wrote:
> We are trying to define the best specs for a windows based Firebird 3 64
> bits instance.
> Based on our knowledge, and the type of applications running we know we will
> need the best possible performance for 1 to 10 concurrent users demanding
> queries (reading not writting) from just a few relational tables. We will
> organize indexes and the question here is "what would be the best server
> configuration". We believe the following:
> 1) We need the best processor, that can process the fastest per core, not
> combined, as FB will run each request (sql select statement) on a separate
> core, and because we will have up to 10 concurrent users we only need a
> processor that has 10+ cores (all available new processors support that,
> either on its own or on a dual processor configuration). The benchmarks
> available on internet compare "the processsing capacity of the hole
> processor, including all cores", so we don't have a "comparisson one core
> against one core of another processor".
> We believe the following processor would be the best:
> Platinum 8156 Processor
> Anyone has a better suggestion?

To be honest, with only 1-10 concurrent users, the processor is hardly
going to matter for performance. Database work is - usually - not very
CPU-intensive and mostly IO-bound.

Mark Rotteveel