|Subject||Re: [firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits|
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).
Thank you Mark!!
So the key here would be RAM and SSD disks correct?