Assuming top speeds on both drives:
The SSD would need ATA166 (I am guessing).
But here's the thing, platter based drives are slow as hell. You would get better real world performance from a SSD on ATA33. (However I don't suggest running it this low).
Also, the bottleneck on the SSD would be bus-side, whereas the bottleneck on the HDD is drive-side...
If you're really concerned, get a SATA SSD. Problem solved.