SCSI is fastest. Some newer SATA drives come close, but SCSI has it's own processor and will tend to reduce CPU stress as well.
For static content, IDE drives would do really. IO congestion usually happens with database servers as database queries require fast read access. This is where SCSI, and especially SCSI RAID0 shines.