Keep in mind that it is a database. But not an HR complex one.
Just full table scans and summarize.
4 cores with 8GB can handle large environments.
you are doubling it already.
You can start with that to evaluate how it behaves.
But raid5 is not ideal for databases. Try to use raid10 to improve performance.
Hello & Thanks for you input.
I´ve checked the performance on both a 400C (our current old model) and in my lab with a single Intel 320 disc.
The information I found was noteworthy. It seems that somehow Fortinet managed to handle the database so that it is using maximum sequential real with QD = 32. Since I didn´t have any NvME drives availible for testing, I was unable to see if it scaled further.
The 3510 will scale really well in Raid 5. I think it´s an old misconception that the performance is inadequate and that it belongs to the slow HDD era.
We were first thinking of a FAN 1000D appliance. But since it´s based on HDD:s that will yeild horrible performance.