I'm facing some performance issues on an integration flow developed in Boomi. In this flow I read historical data from SuccessFactors Employee Central and after a mapping in which I define some logics and transformations on data I send the documents to a MySql Database (an example is provided below)
I find out that Dynamic Inserts operations into the tables defined in MySql are very slow (they take about one hour to insert about 25k records)
Is there a way to improve the performance of these operations directly in the integration flow developed in Boomi?
Thanks for the help,