Common performance tips

Combine multiple identical transformations into the single Flow

If there are multiple source-destination transformations of the same type (for example, data migration from one database to another), combine all of them into a single Flow:

Enable parallel processing

If you are loading data into multiple database tables in parallel, make sure that there are no reference constraints or the reference constraints are disabled. Otherwise, you might get a reference constraint violation exception.

Use parallel loops when iterating through a large number of identical tasks

Read about parallel loops.