Skip to main content

Nested query complexity and rate limit

  • September 24, 2020
  • 3 replies
  • 2186 views
StefanSays

I’m using the GraphQL API and I’m not sure if the issue I’m facing is due to an error or a mistake on my side. I’m trying to get all groups and items on a particular board. While the query works in general, it has a complexity that doesn’t make sense to me. The query complexity seems to assume I potentially parse all items in the account, not only the ones in the specified board. Here is my query:

{
boards(ids: 123456789) {
groups{
title
items(limit:100) {
name
column_values(ids: [“firsti_d”, “second_id”]) {
text
}
}
}
}
}

Running the query with different limits on “items” gives the same result, but with vastly different complexity, making me hit the rate limit really quickly, although the board is rather small. A workaround might be a limit in groups, but that doesn’t seem to exist?

      This topic has been closed for replies.

      3 replies

      AlexSavchuk
      Forum|alt.badge.img
      • AlexSavchuk
      • monday.com Team Member
      • September 24, 2020

      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

      StefanSays
      • StefanSays
      • Author
      • New Participant
      • September 24, 2020

      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.

      AlexSavchuk
      Forum|alt.badge.img
      • AlexSavchuk
      • monday.com Team Member
      • September 27, 2020

      @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

      Terms & ConditionsCookie settingsAccessibility statement