Bulk Record Creation

[sb458]

I have a requirement where I have to create Engagements for all the Companies(core_company) which has an associated supplier in Supplier (sn_fin_supplier) table.
Note: There are close to 2 lacs records in Supplier table. I could not create any custom field on Company table.
How can I make sure Engagements get created for all the companies either in batch or one go considering performance?

[Hanna_G]

Hi @sb458 

Could you do this using Flow Designer? 
Trigger - Run Once
Then do a look up Companies with supplier, and for each Create Record - record type Engagement? 
You would need to increase the number of times to execute to match the size required. 

[sb458]

Can you elaborate more on " Increase the number of times to execute to match the size required."?

[Hanna_G]

Hi @sb458, 

In your Look up records step there is a Max results option: 

Update here to ensure that you capture all of the records needed. 

[JaredNash]

Use scheduled script or Flow Designer with batch processing and pagination to handle large data safely.