Retool Mobile app crashes when query returns ~1500 rows (works fine on Desktop)

💬 Mobile
1

Hi Retool team,

I’m running a Retool mobile app that uses Mapbox to display markers based on a query result. The query returns around 1500 rows — mostly coordinates and a few text attributes.

The app works perfectly on Retool Desktop/Web, but on Retool Mobile, it crashes.

I reduced rows to ~200 and it seems to work on mobile. So it looks like either:

  • There’s a memory or rendering limit on mobile Mapbox components, or

  • Mobile Retool has trouble handling large datasets in JS queries/components.

Environment details:

image
image1920×939 77.5 KB

2

@engineering-tajir -

Couple thoughts

  1. could you have the data for each point run on click?
  2. Its fairly common on map views for apps to have a limit (if you google cafe on google maps for an entire city, you don’t see every cafe)
    1. From here, you could have it limit to a safe number and then on change of the viewport of the map you can retrigger the query

Hope that helps!

3

Hi @engineering-tajir! Like @DavidD said, it is fairly common to have a limit of data points on a map view, even on desktop apps. So regardless of the context, it makes sense to limit or filter the results you plan on populating your map with.

To answer your question though, technically the query payload limit on all of retool is 100MB, so you won't get a specific error about payload size unless you hit that limit. On Retool Mobile however, you'll run into significant performance impacts or crashes around 1.6MB - 3MB, just due to mobile connection limitations. This translates to about 500-2k rows of data, accounting for Retool's overhead.