John, the performance gap between IDE and SCSI opens wide as soon as multiple tasks need to be fulfilled. SCSI drives can take multiple read/write requests at the same time, and rearrange, sort and complete them in any order that lets the drive perform best - e.g. minimizing rotational latency by fetching the data first that spin by the head rack next.
IDE drives take only one command at a time, which implies an in-order completion with far less than optimal head movement and rotational latency.
That's why I said this is really going to show when the server has to get serious about its serving business.
Of course, SCSI HDDs must have a far more sophisticated and powerful firmware inside to achieve this. This development effort and brainpower is part of why SCSI HDDs are more expensive.
If you want to see numbers, go to
www.storagereview.com, Performance Database, and look at the "Server DriveMark" numbers. The bestest IDE drives - WD's Raptor Series-II drives - cannot even keep up with SCSI drives from two years ago. Today's top notch SCSI drives are up to 80 percent faster.