Scheduled Automation Error: Took too long to process

[JuneCorpuz]

Hello-

Has anyone encountered this error before?

The bot was updating a column (with complex Appsheet formula which contains 20 lookups to compute for the score based on the other fields) for 5000 records in one table but encountered this error and stops somewhere in the middle.

Additional Question: What is the fastest way to update the rows in the table? Because If I have 5000 rows and the average execution time is 3s, it will take the app to update all the rows by 4.16 hours.