Updating 40K records Comments on sysapproval_approver table using background script

[srivasareddyy]

Hi ,

When I try updating comments on 10k records using a query with a set limit on the sysapproval_approver table, it's taking more than 5 minutes.

Can anyone suggest a way to update 40k records within 5 minutes?"

We are disabling few notifications and business rules while running the before Background script.

[srivasareddyy]

Hello Brad,

Thank you for your response. The 'comments' field is a journal input data type. If we set setWorkFlow('false'), the comments are not updating in the mentioned table; they are instead updating in the journal inputs storage table.