Use prefetch_related for threads to improve thread loading speed

boards/models/post.py

@@ -430,8 +430,7 b' class Thread(models.Model):'
         Gets sorted thread posts
         """
 
-        # return self.replies.all().order_by('pub_time')
-        return self.replies.all().order_by('pub_time').select_related()
+        return self.replies.order_by('pub_time').all().prefetch_related('referenced_posts')
 
     def add_tag(self, tag):
         """

boards/templates/boards/post.html

@@ -68,16 +68,14 b''
                     {{ post.text.rendered }}
                 {% endif %}
             {% endautoescape %}
-            {% with refposts=post.referenced_posts.all %}
-                {% if refposts %}
-                    <div class="refmap">
-                        {% trans "Replies" %}:
-                        {% for ref_post in refposts %}
-                            <a href="{% post_object_url ref_post thread=thread %}">&gt;&gt;{{ ref_post.id }}</a>{% if not forloop.last %},{% endif %}
-                        {% endfor %}
-                    </div>
-                {% endif %}
-            {% endwith %}
+            {% if post.referenced_posts.exists %}
+                <div class="refmap">
+                    {% trans "Replies" %}:
+                    {% for ref_post in post.referenced_posts.all %}
+                        <a href="{% post_object_url ref_post thread=thread %}">&gt;&gt;{{ ref_post.id }}</a>{% if not forloop.last %},{% endif %}
+                    {% endfor %}
+                </div>
+            {% endif %}
         </div>
     {% endcache %}
         {% if is_opening %}