When I'm doing large data transfers I try to find a way to break them up into no more than 30mil per set. I'll have them all in one data flow but running 10 or 15 at the same time speeds things up nicely.

Dropping them into a heap and applying the constraints/indexes later also speeds it up as you found out. 😀