Which server to choose for the project?

Question

System administration

There is a project in which there will be tables with a huge number of records
. What should the server have?
Emphasis on a powerful processor, the amount of RAM or disk speed?

Answer 1

Tables "with a huge number of records" is not a sentence, given the widespread introduction of SSDs and the possibility of partitioning.
Choose the minimum-reasonable configuration, conduct load testing. If the performance does not suit you, look at what has rested and add the appropriate resource. What to focus on depends on the specific case, there is no universal advice. In general, DBMSs love it when indexes fit completely into memory.
All this is true if you are confident in the performance of the application itself, and also, of course, implies virtualization.

Answer 2

To begin with, I would answer for myself more specifically, how much is a huge number of records. How much change over a period of time. reliability requirements. Well, yes, I conducted performance testing, even before the purchase, at least on the desktop.