Error: too much computing time
August 28, 2018 at 9:58 pm #1254QuirinParticipant
I have recently edited my TAGS sheets and set their triggers to 15 min instead of the original 60 min in order to try to approach the maximum Twitter API rate limit. It first seemed to run okay, I tested and compared results between two sheets.
However, now I’m getting emails reporting errors for many of my sheets (total: 35) containing the error message ‘the service requires too much computing time for one day’ (translated from German) by the function
getTweets. They seem to keep on collecting tweets though.
What is this about and what can I do?
August 30, 2018 at 6:39 pm #1262mhawkseyKeymaster
- This topic was modified 5 years, 1 month ago by Quirin.
Hi – sounds like you are hitting the quota Google provide for running scripts in Google Sheets https://developers.google.com/apps-script/guides/services/quotas#current_quotas If you are running via a Gmail account then G Suite accounts are more generous … or split the load across multiple accountsSeptember 7, 2018 at 10:44 am #1266QuirinParticipant
Thanks for your answer! I’d like to stick with my single Gmail account for several reasons, so I guess I’ll have to switch back from 15 to 60 min intervals for the
getTweetstrigger. My only concern for that is that I’d get less than the maximum number of tweets that could be harvested for my queries, as the absolute frequency of tweets for those queries are crucial for my research project. Would I get a warning or error if I hit that ceiling?September 13, 2018 at 7:52 pm #1271mhawkseyKeymaster
No unfortunately I don’t think the script throws an error if reaches the collection limit and there are more tweets.
- You must be logged in to reply to this topic.