Using an expensive adapter (more than 80 EUR) such as those SCSI to IDE is a non sense in this case. If you have SCSI, it's better to use a fast SCSI drive.
If you have IDE (Buddha or other), it makes sense to have a tiny and silent CF card, even if you will get poor speed from it.