i'm not too sure what the 400d's write speed is but i know the 350d maxes out at about 6mb/s? so i think any card that is faster than that should be fine for the xti.
if you want to be able to burst forever, you'll probably need a card that does like 30mb/s (assuming a shootrate of 3fps and then each file being about 10mb)