On 19-5-2018 15:00, fabia...@itbizolutions.com.au [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