Hi Glide team,
I’m building an internal dashboard in Glide to track key metrics for my cleaning business. Unfortunately, the built-in charts are quite limited — they only display basic visuals without interactive filtering — so I decided to create many query columns in the Data section (since I couldn’t find another way to retrieve filtered results).
Each query pulls specific metrics (like services completed, hours worked, clients acquired, etc.) across different categories and date ranges. For example, I need to see how many services were done in a certain city (e.g. Montreal), during a specific date range (e.g. June 1–30), and divided by service type (1. Regular Cleaning, 2. Deep Cleaning, 3. Airbnb). Since Glide doesn’t offer that natively in the charts, I’ve had to build it manually with queries and display the results as text.
But ever since I implemented this setup, my entire team has been experiencing serious performance issues. The app now takes a long time to load (sometimes failing entirely with a timeout error). Buttons can take up to a minute to respond, and this is happening across all ~80 users — not just a few.
To produce a simple breakdown like the one below:
I had to build about 12 query columns plus 12 rollup columns, and similar structures exist across multiple tabs. Here’s an example of what the data logic looks like:
I’m fairly convinced that the high number of queries and rollups is what’s slowing down the app, since this all started happening after I added them.
So my main question is:
→ Can having too many query columns significantly impact app performance in Glide? And if so, what’s the best way to build a dynamic, filterable dashboard without compromising speed?
To be clear, I’m not trying to do anything overly complex — just replicate this type of view from Google Sheets:
But I can’t get even basic segmented metrics (like sales by city or bonuses by type) without dozens of backend queries and rollups. Without filtering options in the default layout charts, it’s extremely limiting — and the workaround is killing performance. To be clear, i know that some charts have date range filters, but it only applies to the chart, all the text info will rest unfiltered, which make it useless.
I’ve moved my entire business over to Glide and I really want to make it work, but so far, it’s becoming more difficult and slower to use than what I had in Google Sheets 
If any experts offer 1-on-1 consultations (even paid), I’m open to that. I’d really appreciate any guidance or solution — I need to fix this urgently.
Thanks so much in advance!
