Discover how to enhance your application's performance using snapshots in this 24-minute PyCon US talk by Juan Gonzalez. Learn about the challenges of database bottlenecks and explore a novel approach to improving Python code efficiency without increasing costs. Delve into the open-source library "snapshot-queries" and its potential to help scale your application. Explore the unique aspects of query tuning, the pros and cons of ORMs, and how to overcome common database-related issues. Gain insights into the top 5 features of query snapshots, including query inspection, summary generation, and stacktrace analysis. Understand how to implement automated testing with Query Snapshots to optimize your code and boost overall system performance.
Overview
Syllabus
Improving app performance with snapshots
application is unique
Query tuning is hard
But it can be worth it
ORMs are great...
But ORMS make query tuning harder
You make the perfect restaurant app
You need to save it to your database
ORM problem
But query tuning can be easy
Query snapshots
Top 5 features
Inspect any query
Beautiful summaries of all
See the full stacktrace for each
Group together similar SQL
Query Snapshot automated testing
Questions?
Taught by
PyCon US
