Menu
Is anyone else having performance issues with Apps Script Apps?
I have 9 apps that suddenly started performing very slowly on Friday. The common link between them seems to be ScriptDB although I am not sure that this is the issue. I wonder if this has anything to do with ScriptDB being deprecated at the end of this year?
I am seeing the following error far more frequently than before:
Service invoked too many times in a short time: scriptdb rateMax. Try Utilities.sleep(1000) between calls.
Thanks in advance
Stuart
565
As your browser stores more cache and cookies, it could slow down. Clearing the cache and cookies can fix issues with items taking longer to load. See Clear cache & cookies. Browser extensions and plugins can sometimes cause issues with Google Docs, Sheets, Slides, or Forms.
Use batch operations Alternating read and write commands is slow. To speed up a script, read all data into an array with one command, perform any operations on the data in the array, and write the data out with one command.
If an entire column range is selected in a named range, it will slow down google sheets as sheets will run calculations across all the cells in the row or the column, even if they're blank.
Google Ads scripts for advertiser accounts can execute for a maximum of 30 minutes, after which they will be cancelled. All of the changes made before the script was cancelled will be applied.
Yes ive seen it too in my scripts. Lately scriptDb has apparently gotten more strict about rate limits. I have a script running continuously over 1 year and got that same error twice this week, and none for many months.
137
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
