Result exceeded maximum size of 100 MB

I get an error says Result exceeded maximum size of 100 MB

how can I solve it?

Hi @R_S_I_F - This sounds like an error message you received when running a large query on a resource. 100mb is indeed the limit for the Retool Cloud offering.

Have you looked into server-side pagination if this is a database query? Can you share anymore details so we can brainstorm ideas together?

1 Like

This is a query that gets raw data from the DB so I can use it on a JSON SQL Query for insights

Thanks for clarifying @R_S_I_F . This limit cannot be increased for Retool Cloud customers though. It sounds like server-side pagination may not work but maybe you can look into reducing the number of columns/rows you request and/or use workflows to batch some of the analysis.

When are you planning to increase this limit for the cloud product?

Hi @R_S_I_F there are no imminent plans to increase this limit. Limits like these are necessary to maintain a healthy infrastructure for all cloud customers.

Please do consider server-side pagination, batching, or other methods of breaking up the large requests.

Any idea how I can accomplish one of your options while getting the needed result?

Hi @R_S_I_F no promises or guarantees, but if you share a bit more about what you're trying to do, perhaps others in the community can chime in and take a look.

I suggest starting a new conversation so it gets more attention and framing the topic as how to achieve this while taking resource limits into account (not how to raise the limit). I think having some sample data inputs and what you're trying to achieve (outputs) will increase the chances that someone will be able to come up with an idea that could help!