Help

Re: Bulk update - can I speed this up?

Solved
Jump to Solution
939 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Mullin
6 - Interface Innovator
6 - Interface Innovator

Hello,

I have a table with about 1700 records. I’m pulling a couple of records and doing some math on all the rows, then updating the result in a new record. The bulk update code I’m using is waaaay faster than a single row update, but it’s still taking about 45-60 seconds. That’s too slow for me to run an automation, which has a 30s timeout. Is the following code inefficient?

while(updatedRecords.length){
await table.updateRecordsAsync(updatedRecords.splice(0,50));
}

Regards,
Scott

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

You code isn’t inefficient. It just isn’t as efficient as you need it to be.

This thread has suggestions for dealing with updating thousands of records in an automation.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

You code isn’t inefficient. It just isn’t as efficient as you need it to be.

This thread has suggestions for dealing with updating thousands of records in an automation.

Thank you! I don’t have to update every record, so that’s a great suggestion.

Do you have any examples of a mega batch update? I would have approached it the way it was discussed in the thread, but I got the impression that did not work.