Blog126.4K views4,318 votes1 reply1 comment4,828 following
select_related vs prefetch_related: Fixing Django N+1 Queries
Stop N+1 queries in Django by choosing select_related for foreign keys and prefetch_related for many-valued relations, then verify with SQL logging.