I am writing an application for a client that says he will have 20 orders / day and that will increase to 200 within 2 years.
He wants to have his own local server for that and wants me to suggest him a PC specification that may supply his needs for N years say 7~10.
The database will be mariadb.
What data do I need to look at to evaluate that?
My initial idea is to generate data to cover for 300 daily records for a year and then calculate based on that.
I will be writing an app that writes dummy data to the db using N connections to emulate concurrent insert, reads, etc, not sure if this is a good way to do this either. What are your advice?
But I am not sure how I would calculate memory, cpu and disk io into the equation only the disk space.
How can I calculate the memory cpu and disk io for this purpose to know say what sort of HD/SSD/M2 or cpu and memory that it would require?