Loading...

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

536 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 29, 2020

Presented by:
Chris Seto

N+1 queries are as common as blog posts about how to solve them. What happens when you want to get a list of blog posts, the comments on them, and the comments’ respective authors? An exponential number of queries. The rise of GraphQL and REST APIs that provide “include” semantics make these situations increasingly common and painful. Clever use of prefetch_related and select_related may help in a pinch but never fully solve the problem. Learn how to identify these inefficient queries and optimize them using SQL aggregations and LATERAL JOINs.


Talk slides: https://docs.google.com/presentation/...
Talk resources:
- Companion Repo: https://github.com/chrisseto/pycon202...
- Mentioned Library: https://github.com/chrisseto/django-i...

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...