Big O No - Django ORM Runtime Complexity and How to Avoid It Using LATERAL JOINS

Discover how to optimize Django ORM queries and avoid runtime complexity issues in this 16-minute PyCon US talk by Chris Seto. Learn to identify and solve N+1 query problems, which are particularly common in GraphQL and REST APIs with "include" semantics. Explore advanced techniques beyond prefetch_related and select_related, including SQL aggregations and LATERAL JOINs. Gain insights into efficiently retrieving complex data structures, such as blog posts with comments and their authors, without exponential query growth. Access the talk slides and companion GitHub repository to deepen your understanding of Django ORM optimization techniques and discover the mentioned library for implementing these solutions in your projects.

Talk: Chris Seto - Big O No: Django ORM runtime complexity and how to avoid it using LATERAL JOINS