How to avoid n+1 select in django?
For ForeignKey, you can use selected_related():
Comment.objects.select_related('video').all()It will generate one query only, gathering coments for you as well as videos.
For something more complex (such as M2M), you need an external app such as unjoinify to make optimizations but it uses SQL queries to then put them back in objects.
If you are unconfortable with this (I am), you have some alternatives:
- django-queryset-transform: not a full solution, but helps
- django-batch-select: roughtly a
select_relatedthat works with M2M and reverse relations.
What you need to do is use the select_related on the Comment.
Lets say you need to find the all the videos whose title starts with 'The' and the comments related to it
comments = Comment.objects.filter(video__title__starts_with='The') .select_related('video').all()This will load all the comments and the appropriate Video object for that comment. You will still need to pivot over the Video to iterate over the videos. Use the python itertools.groupby function to do that pivoting in memory.