Hi everyone,
I’m seeing major performance issues in my Glide app and I’m hoping to get advice on best practices / architecture.
Context
-
Data source: Glide Tables
-
I have tables with 500- rows, about 5 tables with 2k+ rows and 1 big table with about 10k rows
-
My “Services” table is a Big Table with ~10,000 rows (this is the core of the app).
-
The app is generally fine, but one tab becomes extremely slow / basically freezes when opening it.
What I’m seeing
-
In Performance Analysis, several computed columns (mostly Query columns that query the Big Table) are taking ~6,000–10,000ms to compute (some even higher).
-
The slow tab depends on these queries (they feed rollups / metrics / lists), so when that screen loads, everything stalls.
My current setup
-
Many Query columns are filtering the Services Big Table by cleaner / city / date range / service status, then I use rollups (COUNT/SUM) for KPIs.
-
I need the Services table to stay as the main database, so I can’t just “remove it”. and i cant use relations since im bringing info with 4 or 5 filters
Happy to share screenshots of the Performance Analysis icons/timings and an example query config if that helps.
Thanks!