Improving App Performance with Snapshots
summary
Claim: an open source library named snapshot-queries captures every ORM query, the triggering Python line and full stack trace, groups similar queries to surface N+1 patterns, prints readable summaries, and plugs into tests as query snapshot testing. Built at Cedar for Django/SQLAlchemy workloads in 2019 and run in CI it reduces database load and catches regressions before deployment. Watch if concrete tooling and testable, repeatable fixes that actually worked at scale matter.
AI-written summary · about
chapters (16)
- 0:00Improving app performance with snapshots
- 0:56application is unique
- 3:57Query tuning is hard
- 4:41But it can be worth it
- 6:02ORMs are great...
- 6:23You make the perfect restaurant app
- 6:54You need to save it to your database
- 9:58ORM problem
- 12:28But query tuning can be easy
- 13:16Query snapshots
- 15:40Top 5 features
- 16:34Beautiful summaries of all
- 17:30See the full stacktrace for each
- 18:28Group together similar SQL
- 19:41Query Snapshot automated testing
- 22:54Questions?
related talks
01h 58mNo More Raw SQL: SQLAlchemy, ORMs & asyncio
26mA Related Matter: Optimizing your webapp
37mAccelerating Python Analytics by In-Database Processing
25mBuilding effective Django queries with expressions
29mSwiss Army Django: Small Footprint ETL
52mLightning Talks - Saturday, May 17
47mReal World Django Q&A
17mOff the Beaten Path: Exploring Unusual Roads to Django Performance