Hey @StefanSays 👋
Great first post and thank you for allowing us to help here! My warmest welcome to the community and I hope you enjoy your stay with us 🙂
Just to clarify, are you querying this on a Trial account or on a Paid account? The reason I’m asking is that Trial accounts have a 1,000,000 complexity limit per minute, while paid accounts have 10,000,000, which might make the difference here.
As for a limit in Groups, you could definitely specify the exact group IDs you’d be looking to query., which could help you with the complexity limits here. That said, I was wondering if you’d need to make this type of query frequently? The complexity rate refreshes every minute, so perhaps using a delay or a timeout would work in your case?
-Alex
Hi Alex, thank you for the quick reply! We are on a paid account, so the rate limit is the higher one. The query produces a very high complexity score of over a million, whereas I believe the actual complexity is quite limited, as it’s only one board I’m hitting. It’s not really that I think we’ll have more than 7 of these requests a minute, which would make us hit the rate limit, but I’m still trying to understand on how to potentially create queries with a lower score. Splitting the query into two, calling the groups and the items separately produces a much, much lower complexity, but then the implementation effort on our side is a lot higher.
@StefanSays
Thank you for providing your line of thought here and I appreciate further context to what you are looking for here.
I do think that the more “general” your query is, the more data you are pulling in at a time, thus getting a higher complexity cost per query. For mutations, it definitely makes a lot more sense to bulk up what you’re looking to send to the API - for example, instead of using multiple change_column_value queries, using a single change_multiple_column_values query.
That said, I definitely understand how trying to workaround this by using targeted queries also puts a lot of extra effort on your developer’s plate. Perhaps someone within the community can provide helpful pointers to how to manage this more efficiently from a frequent user’s point of view?
-Alex