SQL performance: Memory or CPU
What is more important to SQL: Memory or CPU?
I mean to get good performance for SQL, what plays more important role? Thanks |
It depends a lot on your setup and the SQL server you'll be using but assuming a decent CPU you'll usually end up being IO bound (ie. buy the fastest disks possible).
--jeremy |
Re: SQL performance: Memory or CPU
Quote:
|
MySQL
|
mikeshn,
In my experiance the biggest performance win with MySQL is usually making sure all SQL queries in a given app are tuned properly. As far as hardware goes you are still leaving out too many variables for a solid answer. Memory and disk are very important though. I would also recommend reiser for the filesystem. You'll also need to monitor performance and tweak the MySQL config a bit in the begining. --jeremy |
Quote:
|
All times are GMT -5. The time now is 08:24 PM. |