| Subject | Re: [firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits |
|---|---|
| Author | livius |
| Post date | 2018-05-22T20:45:23Z |
Hi,
as always RAM is crucial for DB, but with such size of DB you can only
benefit “a little”
I do not know the reall usage scenario – what data is used and how many
data are “analyzed” by normal user.
Does database contain historical data not comonly accessed or user “scan”
whole db every day?
You must check how the usage looks like – how many phisical reads you got
every day.
If you see very big number with big RAM then your only way to speed things
up is storage.
I have worked with 680 GB FB with 256 GB RAM and for me RAM was crucial,
cache do the job.
But in my scenario there was “historical data” accessed only occasionally
(once per day).
regards,
Karol Bieniaszewski
Sent: Sunday, May 20, 2018 7:08 PM
Subject: Re: [firebird-support] Choosing best server / processor for
Firebird 3.03 64 bits database on Windows server 2016 64 bits
Thank you Mark!!
So the key here would be RAM and SSD disks
correct?
Cheers,
Fabian