Database Server Hardware components (order of importance), CPU speed VS CPU cache vs RAM vs DISK
- by nulltorpedo
I am new to database world and would like to know what are crucial hardware specs when it comes to database performance. I have searched the internet and found this so far (In order of decreasing importance):
1) Hard Disk: Get an SSD basically (much more IOPS than spinners)
2) Memory: Get as much as you can afford
3) CPU: For the same $ spent, prefer larger cache size over speed.
Are these findings sensible?
EDIT: I would like to focus on CPU speed VS CPU cache size.
EDIT2: The database is used to store some combination of ints and int arrays with few text fields. There are a lot of Select queries looking for existing entries. If entry is not found, then insert it. I would say most of processing would be trying to find a match across a table with 200 columns and 20k rows. The insert statements are very few.
EDIT3: Also, we have a lot of views (basically select queries).