select_related vs prefetch_related
select_related joins single-valued relations in SQL; prefetch_related fetches related collections in extra queries.
- select_related for FK and O2O
- prefetch_related for M2M and reverse FK
- Both reduce N+1 queries
select_related vs prefetch_related