Events overview empty - result exceeded max size

💬 App Building
1

Hi,
i was working in ticketify and when I suddenly my page was empty and I couldn't see any ticket action anymore.

Do you know why? I did got a notification at the bottom right with 'eventsoverview - result exceed mamimum size of 100 MB

Thank you for solving this issue asap as I have some actions launching this week and absolutely need to have the vouchers.

image
image800×358 21.1 KB

thank you for contacting me by email on margot.vansteenkiste@roularta.be as the email of the account is a general email i don't have access to.

2

Hello @Partner_orders_RMG, welcome to the Retool Community! :raised_hands:
This is expected behavior in Retool. The error message “result exceeds maximum size of 100 MB” appears when a query returns a very large result set. The 100 MB limit applies to Retool Cloud.

A couple of things you can try:

  • Add filters to your query so only the relevant tickets are returned.
  • Implement pagination so the data loads in smaller chunks rather than all at once.

Does either of these solutions sound like it could work for your use case?

3

hi ChiEn,

thanks! Is there a way you can show me how I can do both of you suggestions? filters and implementation of pagination?

I already tried with filter but that doesn't seem to work so I would be happy to learn how to :slight_smile:

4

Sure thing! I can guide you through this. Can you share a Loom or screenshot of how you’re currently setting up your filter so I can get a better idea?
In the meantime, here are some docs that might be helpful as references:

5

Hey @Partner_orders_RMG how is it going? Were you able to set up your filter?

Thanks! :pray:t3: