Error: too much computing time
Home › Forums › Advanced usage › Error: too much computing time
- This topic has 3 replies, 2 voices, and was last updated 5 years ago by
mhawksey.
-
AuthorPosts
-
August 28, 2018 at 9:58 pm #1254
Quirin
ParticipantHello,
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?
Best,
Quirin-
This topic was modified 5 years, 1 month ago by
Quirin.
August 30, 2018 at 6:39 pm #1262mhawksey
KeymasterHi – 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 accounts
September 7, 2018 at 10:44 am #1266Quirin
ParticipantThanks 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
getTweets
trigger. 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 #1271mhawksey
KeymasterNo unfortunately I don’t think the script throws an error if reaches the collection limit and there are more tweets.
-
This topic was modified 5 years, 1 month ago by
-
AuthorPosts
- You must be logged in to reply to this topic.