Ubidots Community

Max value for the page_size parameter

Hello!

I’m currently creating a GraphQL wrapper for Ubidots API, everything has been working OK until today that I started implementing the Resolver Chains (this is a “fancy” way of calling the nested queries) as I’m having issues with the N+1 problem and the throttling of the API.

One way to fix this N+1 problem when having access to the DB is to make two separate queries asking for all the data and tying up the data in memory, the DB is accessed two times instead of being accessed multiple times (N+1, hence the name), that works great if I had direct access to the DB, but this is obviously not the case here. So one way I’ve thought to workaround this problem is to get all the variables of the account but I’m not 100% sure what is the max value that is supported by the page_size argument and if it’s safe to use it (it won’t change).

PS: I’m having another problem with the API and it’s that the response from the server doesn’t include the Cache-Control header and hence the GraphQL doesn’t use the default cache strategy. I made a workaround on this by using a custom cache strategy. But it’d be great if you could check if the Cache-Control could be implemented.

Greetings!

Greetings,

the max value allowed for the page_size parameter is 200 with the exception of variables related endpoints, which is 500.

Thanks for the suggestion, we do not have any plan to add this header in the middle term, but I will add your request to our feature request query.

All the best