performance: prefetch categories in listen page (190 -> 12 SQL queries)

diff --git a/panikweb/views.py b/panikweb/views.py
index 2a81471a4c711c5ef0b4c1fac812c1469013ddac..4cf180614f0abdacf773eabd3e5984417b003ce4 100644 (file)
--- a/panikweb/views.py
+++ b/panikweb/views.py
@@ -482,7 +482,7 @@ class Listen(TemplateView):
     def get_context_data(self, **kwargs):
         context = super(Listen, self).get_context_data(**kwargs)
         context['sectionName'] = "Listen"
-        context['episodes'] = Episode.objects.filter(
+        context['episodes'] = Episode.objects.prefetch_related('emission__categories').filter(
                 soundfile__podcastable=True, soundfile__fragment=False) \
                 .select_related().extra(select={
                     'first_diffusion': 'emissions_diffusion.datetime', },