You notice on SCSI cables that the drives are added starting as close as possible to the terminator, which is at the far end of the cable. I'm not an expert on SCSI, but I believe that is to prevent signal bounce on the tail end of the cable as much as possible.
With IDE, I would put the fastest drive on the end of the cable so there is no signal bounce due to vacant cable beyond it. This might be one of the reasons that IDE cables are "officially" not supposed to be over 18 inches long.
Realistically, however, I have run enough HD Tach benchmarks to conclude that it's not really making any difference on an 18" IDE cable, no matter where the HDD is plugged in. With longer IDE cables, I don't know, but there are situations where 18" is not really enough. Maybe Serial ATA will help with that problem, whenever it arrives in mainstream products.