The shorter the cables are, the better, from the point of view of performance and minimising errors. 24" is the longest I've seen around, and the longest I would want to use.

The specified maximum cable length for UDMA66 upward is 18"