You may want to check out
this thread for a healthy discussion about this.
rpstewart, I don't really know where you got your figures from, but they're totally wrong - sorry to say.
A 10K scsi drive will thrash any 7200rpm sata drive hands down, and to put things in perspective, a 15K scsi or SAS drive will pretty much leave everything standing.
You forget that SCSI is designed to handle higher sustained throughput on the I/O sphere than a sata as although the theoretical maximum is 3GB/s the true speeds are much lower, in the hundreds of MB/s.
Wnm0, it really depends on what you're looking to achieve with the drive, not forgetting that SCSI requires dedicated controllers mostly all running on a 64bit PCI-X 133bus.
SAS is the serial evolution of SCSI, but as yet the PCI-e bandwidth for the controllers is still maxed at x8.
Whatever you do, don't rush out and buy a 7200rpm sata if you want speed. The high capacity 7200's get round the speed issue by using large NCQ caches to achieve the data interaction with the controller.
The best current compromise for speed and cost at the moment is the Velociraptor who's 10K speed is vey nearly on par with 15K scsi/SAS devices in sustained I/O
Also, yes a lot of fuss has been made about SSD's but unless you're looking to buy
MTRON msd-sata3035-64's you'll be dissapointed as most SSD's say from corsair, intel and OCZ all have a high read speed but slower write speeds, which is why they boot quickly but ultimately suffer on intensive tasks.
The MTRON units have brutal Read and write speeds but they come at a price you don't even want to think about at the moment.
IMO, I believe that SSD's have still a couple of years ago before reaching maturity.
What I want to know is why you think that something spinning at 10 or 15K can be slower than something that spins at 7200K? Also, the Seagate Cheetah K6 and SAS units like the Veociraptors are on 2.5" platters rather than the more usual 3.5" platters of large capacity 7200's which in iteself means that the r/w head has less track area which in turn means quicker data transfer.
Like I say, it very much depends on what you're trying to achieve, once we know that, we can look at various storage options for you based around a budget range say low / med / high.
I can tell you straight away that your mobo won't have the capacity to run an Ultra320 scsi controller card, and there's not much point settling for an Ultra2 card as there's an associated performance hit.