Optimized threads list.

boards/models.py

@@ -77,7 +77,7 b' class PostManager(models.Manager):'
         threads = threads.order_by(order_by)
 
         if page != ALL_PAGES:
-            thread_count = len(threads)
+            thread_count = threads.count()
 
             if page < self.get_thread_page_count(tag=tag):
                 start_thread = page * settings.THREADS_PER_PAGE

boards/templates/boards/posting_general.html

@@ -22,51 +22,51 b''
     {% if threads %}
         {% for thread in threads %}
             <div class="thread">
-            {% if thread.can_bump %}
-		        <div class="post" id="{{thread.id}}">
+            {% if thread.bumpable %}
+		        <div class="post" id="{{ thread.thread.id }}">
             {% else %}
-		        <div class="post dead_post" id="{{ thread.id }}">
+		        <div class="post dead_post" id="{{ thread.thread.id }}">
             {% endif %}
-            {% if thread.image %}
+            {% if thread.thread.image %}
                 <div class="image">
                     <a class="fancy"
-                       href="{{ thread.image.url }}"><img
-                            src="{{ thread.image.url_200x150 }}"
+                       href="{{ thread.thread.image.url }}"><img
+                            src="{{ thread.thread.image.url_200x150 }}"
                             alt="{% trans 'Post image' %}"
-                            data-width="{{ thread.image_width }}"
-                            data-height="{{ thread.image_height }}" />
+                            data-width="{{ thread.thread.image_width }}"
+                            data-height="{{ thread.thread.image_height }}" />
                     </a>
                 </div>
             {% endif %}
             <div class="message">
                 <div class="post-info">
-                    <span class="title">{{ thread.title }}</span>
-		    <a class="post_id" href="{% url 'thread' thread.id %}"
-			>(#{{ thread.id }})</a>
-                    [{{ thread.pub_time }}]
-                    [<a class="link" href="{% url 'thread' thread.id %}#form"
+                    <span class="title">{{ thread.thread.title }}</span>
+		    <a class="post_id" href="{% url 'thread' thread.thread.id %}"
+			>(#{{ thread.thread.id }})</a>
+                    [{{ thread.thread.pub_time }}]
+                    [<a class="link" href="{% url 'thread' thread.thread.id %}#form"
                         >{% trans "Reply" %}</a>]
 
                     {% if user.is_moderator %}
                         <span class="moderator_info">
-                            [<a href="{% url 'delete' post_id=thread.id %}?next={{ request.path }}"
+                            [<a href="{% url 'delete' post_id=thread.thread.id %}?next={{ request.path }}"
                                 >{% trans 'Delete' %}</a>]
-                            ({{ thread.poster_ip }})
-                            [<a href="{% url 'ban' post_id=thread.id %}?next={{ request.path }}"
+                            ({{ thread.thread.poster_ip }})
+                            [<a href="{% url 'ban' post_id=thread.thread.id %}?next={{ request.path }}"
                                 >{% trans 'Ban IP' %}</a>]
                         </span>
                     {% endif %}
                 </div>
                 {% autoescape off %}
-                    {{ thread.text.rendered|truncatewords_html:50 }}
+                    {{ thread.thread.text.rendered|truncatewords_html:50 }}
                 {% endautoescape %}
             </div>
             <div class="metadata">
-                {{ thread.get_reply_count }} {% trans 'replies' %},
-                {{ thread.get_images_count }} {% trans 'images' %}.
+                {{ thread.thread.get_reply_count }} {% trans 'replies' %},
+                {{ thread.thread.get_images_count }} {% trans 'images' %}.
                 {% if thread.tags.exists %}
                     <span class="tags">{% trans 'Tags' %}:
-                        {% for tag in thread.tags.all %}
+                        {% for tag in thread.thread.tags.all %}
                             <a class="tag" href="
                                     {% url 'tag' tag_name=tag.name %}">
                                 {{ tag.name }}</a>
@@ -75,13 +75,13 b''
                 {% endif %}
             </div>
             </div>
-            {% if thread.get_last_replies %}
+            {% if thread.thread.get_last_replies %}
                 <div class="last-replies">
-                    {% for post in thread.get_last_replies %}
-                        {% if thread.can_bump %}
+                    {% for post in thread.thread.get_last_replies %}
+                        {% if thread.bumpable %}
 			                <div class="post" id="{{ post.id }}">
                         {% else %}
-			                <div class="post dead_post id="{{ post.id }}">
+			                <div class="post dead_post" id="{{ post.id }}">
                         {% endif %}
                             {% if post.image %}
                                 <div class="image">
@@ -98,7 +98,7 b''
                                 <div class="post-info">
                                     <span class="title">{{ post.title }}</span>
                                     <a class="post_id" href="
-                                {% url 'thread' thread.id %}#{{ post.id }}">
+                                {% url 'thread' thread.thread.id %}#{{ post.id }}">
                                         (#{{ post.id }})</a>
                                     [{{ post.pub_time }}]
                                 </div>

boards/views.py

@@ -36,7 +36,10 b' def index(request, page=0):'
     else:
         form = threadFormClass(error_class=PlainErrorList, **kwargs)
 
-    threads = Post.objects.get_threads(page=int(page))
+    threads = []
+    for thread in Post.objects.get_threads(page=int(page)):
+        threads.append({'thread': thread,
+                        'bumpable': thread.can_bump()})
 
     context['threads'] = None if len(threads) == 0 else threads
     context['form'] = form