Hardware affect Database performance

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
3 replies · 4K views
hawaiifiver
Messages
55
Reaction score
1
How would the CPU, RAM and disk storage of a Database server affect the performance of the Database?
 
on Phys.org
hawaiifiver said:
How would the CPU, RAM and disk storage of a Database server affect the performance of the Database?

What are some of YOUR ideas along those lines?
 
As far as I'm concerned, low CPU, RAM, and disk storage would just make the Database slower. Reading and writing to the database could be noticeably slower.
 
Database servers are software. Some are able to take advantage of multi-threading processors (or multiple processors, either), some are not. Disk usage will depend on the size of the data. RAM usage will depend on how many users are connecting simultaneously, and what kinds of operations they are doing. Commercial database servers have beefed up hardware and operating systems, but you can run a simple database almost anywhere for a few users and get away with much smaller specs.

So unfortunately, the answer is, "it depends" on several different details.