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?

[sb458]

Thank you all for your input. I have implemented a fixed script that runs in the background during off hours, and it effectively handles the task.

[sb458 · Accepted solution]

I have implemented a fixed script that runs in the background during off hours, and it effectively handles the task.