app-audit

# Glide App Audit

Comprehensive performance audit tool for Glide applications. Analyzes data architecture and layout design to identify bottlenecks, anti-patterns, and optimization opportunities.

## ⚠️ Read-Only Guarantee

**This tool is 100% read-only and NEVER modifies your app:**
- ✅ Reads data via API (GET requests only)
- ✅ Navigates through Layout Editor to inspect screens
- ✅ Takes snapshots to analyze components
- ✅ Clicks to view settings panels (read-only)
- ❌ NEVER edits columns, components, or settings
- ❌ NEVER adds or deletes anything
- ❌ NEVER saves any changes
- ❌ NEVER modifies data or structure

**Safe to run anytime** - Your app remains exactly as it was before the audit.

## Official Glide Performance Thresholds

These thresholds come directly from [Glide documentation](https://www.glideapps.com/docs/performance-analysis) and [community guidance](https://community.glideapps.com/t/app-performance-tips-tricks-speed/73139):

| Metric | Threshold | Source |
|--------|-----------|--------|
| **Column computation time** | 100ms | [Performance Analysis](https://www.glideapps.com/docs/performance-analysis) - columns exceeding this show ⚠️ |
| **Query column entries** | 10,000 max | [Query Column Limits](https://help.glideapps.com/en/articles/12063345-understanding-query-column-limits-in-glide-apps) |
| **Glide Table rows** | 25,000 max | [Big Tables Guide](https://www.glideapps.com/docs/guide-to-bigtables) |
| **Big Table rows** | 10 million max | [Big Tables](https://www.glideapps.com/docs/big-tables) |
| **Big Table rollup/lookup matches** | 100 max | [Big Tables](https://www.glideapps.com/docs/big-tables) |
| **Collection items visible** | 24 recommended | [Build for Speed](https://www.glideapps.com/blog/build-speed-and-scale) |
| **Image dimensions** | 1,500px max | [Build for Speed](https://www.glideapps.com/blog/build-speed-and-scale) |

### Big Table Computed Column Limits

Big Tables use SQL (AlloyDB) for queries. Only certain computed columns