Django6 min
How to Find and Fix N+1 Queries in Django
A practical guide to finding N+1 query problems in Django with django-debug-toolbar and assertNumQueries, and fixing them with select_related, prefetch_related and Prefetch.
Tag
Performance
3 articles tagged Performance.
Redis7 min
Redis Caching in Django: A Practical Guide
How to add Redis caching to a Django application without shipping stale data: cache backends, key design, the cache-aside pattern, invalidation on save and stampede protection.
PostgreSQL8 min
PostgreSQL Indexes Explained: How They Actually Improve Query Performance
What a B-tree index really does, how to read EXPLAIN ANALYZE, why column order in composite indexes matters, and when adding an index makes a query slower instead of faster.