Hi all, i meet an issue. I have a simple mongodb resource, it connected to collection with 80k documents. In some reasons when im running query it through "Result exceeded maximum size of 100 MB" , but i know that there is limits on aggregation not find. Please help me to find right way to retrive data to retool
Hey @nekitdar!
The 100MB limit applies to any query response that comes back to Retool. If you're finding that the data you're requesting is too large, you might want to try setting up server-side pagination. There's some information on how to configure that specifically for MongoDB in this post from someone who tried it before, but if you'd be willing to share more information about your query (the code itself or a screenshot would be great!) we can look into it with you here as well.
Let me know if either of those links raises any additional questions!
1 Like
What about queries that return an image binary? In my case, Im attempting to create a zip file where one of the images (from GCP) is just over 100MB.
Hey @cjharlin!
Currently, Retool's limitations may make handling these large files difficult. An alternative solution may be to handle the file processing on the server side, using GCP functions.
I wonder if you can create the zip file on GCP and store it in a GCP Storage Bucket, then use its reference link in your Retool application.
You may also consider splitting the file into smaller chunks that comply with the size restrictions or use external services to compress it if image quality is not pivotal.
https://docs.retool.com/queries/guides/files
https://docs.retool.com/queries/guides/files?storage=retool-storage#interact-with-files-on-data-stores