Was on the rocks about which server to choose. Here were the options:
- Dual Xeon 2.8 - 2 gig ram - 2 10k 73 gig SCSI
- Dual dual core Opteron - 2 gig ram - 2 160 gig SATA
The question I had was; Is the performance gain from the 2x dual core opterons greater than the performance decrease from the SATAs?
It's a good thing dani was on hand. Since she had just upgraded her servers for daniweb, she was glad to provide some insight.
It comes down to this. The SATA drives will put an extra load on the CPU vs the SCSI drives will put the load on the SCSI controller. So if you are serving and running the database on the same server, the scsi route might be better; freeing up your cpu for apache.
I am still a bit on the rocks about what is better, so any more insight from others would be greatly appreciated.