changeset 101:4bbb6a9aa317

Forums: use select_related() with get_object_or_404() to reduce queries.
author Brian Neal <bgneal@gmail.com>
date Wed, 16 Sep 2009 00:39:27 +0000
parents eb9f99382476
children e67c4dd98db5
files gpp/forums/views.py
diffstat 1 files changed, 5 insertions(+), 13 deletions(-) [+]
line wrap: on
line diff
--- a/gpp/forums/views.py	Tue Sep 15 03:15:20 2009 +0000
+++ b/gpp/forums/views.py	Wed Sep 16 00:39:27 2009 +0000
@@ -63,8 +63,7 @@
     """
     Displays all the topics in a forum.
     """
-    # TODO: use select_related to save queries
-    forum = get_object_or_404(Forum, slug=slug)
+    forum = get_object_or_404(Forum.objects.select_related(), slug=slug)
 
     if not forum.category.can_access(request.user):
         return HttpResponseForbidden()
@@ -92,14 +91,7 @@
     """
     Displays all the posts in a topic.
     """
-    #topic = get_object_or_404(Topic, pk=id)
-    #TODO: optimize this or package it up somehow
-    # this saves 2 queries vs the get_object_or_404
-    qs = Topic.objects.filter(pk=id).select_related()
-    try:
-        topic = qs[0]
-    except Topic.DoesNotExist:
-        raise Http404
+    topic = get_object_or_404(Topic.objects.select_related(), pk=id)
 
     if not topic.forum.category.can_access(request.user):
         return HttpResponseForbidden()
@@ -136,7 +128,7 @@
     """
     This view handles the creation of new topics.
     """
-    forum = get_object_or_404(Forum, slug=slug)
+    forum = get_object_or_404(Forum.objects.select_related(), slug=slug)
 
     if not forum.category.can_access(request.user):
         return HttpResponseForbidden()
@@ -162,7 +154,7 @@
     """
     This view displays the success page for a newly created topic.
     """
-    topic = get_object_or_404(Topic, pk=tid)
+    topic = get_object_or_404(Topic.objects.select_related(), pk=tid)
     return render_to_response('forums/new_topic_thanks.html', {
         'forum': topic.forum,
         'topic': topic,
@@ -201,7 +193,7 @@
     to that URL. This function is the target of get_absolute_url() for
     Post objects.
     """
-    post = get_object_or_404(Post, pk=post_id)
+    post = get_object_or_404(Post.objects.select_related(), pk=post_id)
     count = post.topic.posts.filter(creation_date__lt=post.creation_date).count()
     page = count / POSTS_PER_PAGE + 1
     url = reverse('forums-topic_index', kwargs={'id': post.topic.id}) + \