Thank you Mark!!

So the key here would be RAM and SSD disks correct?


Cheers,
Fabian

----- Original Message -----
From: "Mark Rotteveel mark@... [firebird-support]"
<firebird-support@yahoogroups.com>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, May 20, 2018 6:31 PM
Subject: Re: [firebird-support] Choosing best server / processor for
Firebird 3.03 64 bits database on Windows server 2016 64 bits


> 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
> --
> Mark Rotteveel
>
>
> ------------------------------------
> Posted by: Mark Rotteveel <mark@...>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>