performance: archive view

(92 queries → 15)

diff --git a/panikweb/views.py b/panikweb/views.py
index 0d423cc8e4512158a42976de2a50a736be0e78e6..4a2cfa7fe713400a1e908f6f8ce4b703ee0f115d 100644 (file)
--- a/panikweb/views.py
+++ b/panikweb/views.py
@@ -392,7 +392,7 @@ class Archives(TemplateView):
     def get_context_data(self, **kwargs):
         context = super(Archives, self).get_context_data(**kwargs)
         context['sectionName'] = "Emissions"
-        context['emissions'] = Emission.objects.all().filter(archived=True).order_by('title')
+        context['emissions'] = Emission.objects.prefetch_related('categories').filter(archived=True).order_by('title')
         return context
 
 archives = Archives.as_view()