Back then IDE drives were consumer stuff and (most) SCSI drives enterprise class, meaning SCSIs had a lower access time and possibly higher rotational speeds (=lower rotational latency and higher throughput).
SCSI has slightly more overhead but usually that's not noticeable.