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.
Overview
Syllabus
Introduction
Aim
Assumptions
Too much Tico queries
Select related and Prefetch related
Too much data
Problem
Aggregation
Subquery
Too much queries
Questions
Taught by
EuroPython Conference
Related Courses
-
Building Web Applications in Django
5.0 -
Working with Django Models
-
Aggregating Data in Django Using Database Views
-
Optimizing Queries for Not So Big Data in PostgreSQL
-
Big O No - Django ORM Runtime Complexity and How to Avoid It Using LATERAL JOINS
-
Going Beyond the Django ORM Limitations with Postgres
