Django Queries Optimization

Explore Django query optimization techniques in this 31-minute conference talk from EuroPython 2018. Dive into strategies for efficiently collecting data from multiple models, moving beyond basic prefetch_related and select_related methods. Learn how to handle complex model structures and implement selection logic within the database using Django ORM. Discover techniques for moving calculations and aggregations from Python code to the database, centralizing logic in querysets for improved performance and easier testing.

Introduction
Aim
Assumptions
Too much Tico queries
Select related and Prefetch related
Too much data
Problem
Aggregation
Subquery
Too much queries
Questions