I need advice on how to make one of my dashboards scalable.
I have a delivery tracking app. In it, I have an interactive dashboard with 3 views: - List of weeks - List of deliveries - Map of deliveries
This view currently loads ~600 deliveries spanning ~6 weeks.
At 600 place markers the map is already pretty laggy. The dashboard is interactive so I can filter the map by week, but this appears to be only aesthetic as the filter is pretty much instant and the map lags just the same, whether I have every delivery visible or just a given week’s worth.
Every week adds around 100 deliveries, so I know I’m just a few weeks away from the map becoming way too laggy, or worse, having deliveries start to go missing in the map.
This view is key as it gives admins a unique birds-eye view into the delivery side of the business.
So far as I can tell, the narrowest bottleneck is the map. Ideally - feature request time! - AppSheet would change the behaviour of map views in dashboards so that: - Map is redrawn with new pins when a filter is applied - Upwards of a certain pin amount, say 1000, map doesn’t render pins and a warning asks the user to further funnel down the data via interactive tables
As a last resort, and for this specific app, I know I can make slices of deliveries out of fixed intervals of weeks, keep adding these slices manually over time, and have separate dashboards for every slice, but this is also unscalable and cumbersome.