AnsweredAssumed Answered

How to improve massive database INSERT operations

Question asked by samuele.vigano020435 on Oct 7, 2018
Latest reply on Oct 13, 2018 by samuele.vigano020435

Hi community,

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,

 

Regards

 

Samuele  

Outcomes