At 06:18 PM 7/11/2006, you wrote:
My understanding is that SCSI has a faster transfer rate, for
transferring large files. A busy database needs really fast access,
for making numerous fast calls all over the disk. Two different,
unrelated things.
I am more than willing to be called Wrong, slapped, and cast from a
bridge.
SCSI controllers have a processor that can queue disk commands thereby
freeing up CPU cycles which makes it ideal for a server. If you are using
the SCSI drive on a single user machine then it's not going to be faster,
and could even be slower than a good IDE drive. I've used a lot of SCSI
drives years ago and paid dearly the price for the drives and the
controllers. SATA II drives may give SCSI a run for their money. But as
others have said, you can get better database performance just by
increasing your RAM.
SCSI drives are also designed to run 24/7 whereas IDE drives are more
likely to fail if used on a busy server. If you really want something fast,
put the data on a hardware RAM drive. If you think SCSI drives are
expensive, you ain't seen nothing yet. :)
http://www.anandtech.com/storage/showdoc.aspx?i=2480
http://www.tomshardware.com/2005/12/05/hyperos_dram_hard_drive_on_the_block/
http://www.hyperossystems.co.uk/
Mike
P.S. Don't jump from a bridge, cause I may be driving underneath it at the
time.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
