NY State-Licensed Certificates in Design, Coding & AI — Online
2,000+ Free Courses with Certificates: Coding, AI, SQL, and More
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
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.
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