From Days to Minutes, From Minutes to Milliseconds with SQLAlchemy

Explore how to optimize database queries and operations using SQLAlchemy in this 45-minute EuroPython Conference talk. Learn to identify and solve the N+1 query problem, implement mass inserts and updates, and dramatically improve application performance. Discover practical solutions for transforming slow database interactions from days to minutes, and from minutes to milliseconds. Gain insights applicable to most ORMs and storage back-ends, making this talk valuable for Python developers working with databases at any scale.

Introduction
Im no expert
Our stack
SQL Alchemy
Frameworks
Python code
Volumes
Implicit queries
Queries
Round Trips
Giroux
Bencher
Code
Convenience attribute
Model serial number
Dynamic Relationships
Debugging
Reading the code
Column Sum
Scholar Method
Further Filtering
Single Hit
Insertion Optimization
Python List
Giant Load
SlowLog