Large Data Creation

0
Hello,   We have requirement where we create more than 50K objects in the background. We are trying to create them through MF but it is taking long time. what should be the best  approach to avoid performance issue. Excel Import or OQL or scheduling or anything else.
asked
2 answers
4

Hi Amol,

go with OQL Query for the large amount of data transaction. https://marketplace.mendix.com/link/component/66876

 

answered
2

Microflows are fine, but you should not do that in one action. It should perform better if you do that in batches. Maybe 1000 Objects in a microflow. This microflow can now be added to the task queue 50 times.

With this pattern, you can make sure that the database transactions are not becoming too big.

answered