Large Data Creation

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.
2 answers

Hi Amol,

go with OQL Query for the large amount of data transaction.



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.