view gpp/templates/ygroup/thread_list.html @ 552:9e42e6618168

For bitbucket issue #2, tweak the admin settings for the Post model to reduce slow queries. Define our own queryset() method so we can control the select_related(), and not have it cascade from post to topics to forums to categories. Removed 'topic' from list_display because MySQL still sucked with 2 inner joins. Now it seems to be tolerable with only one join to User.
author Brian Neal <bgneal@gmail.com>
date Wed, 25 Jan 2012 20:07:03 -0600
parents 0c18dfb1da1c
children
line wrap: on
line source
{% extends 'base.html' %}
{% load url from future %}
{% block title %}Yahoo Group Archives{% endblock %}
{% block custom_css %}
<link rel="stylesheet" type="text/css" href="{{ STATIC_URL }}css/pagination.css" />
{% endblock %}
{% block content %}
<h2>Yahoo Group Archives &raquo; Page {{ page_obj.number }}</h2>
<p>
SurfGuitar101.com began as a Yahoo Group on October 31, 2001. It ran until August, 2007 when this site officially replaced it. On these pages you'll find the archived messages of our original group. You can also search through these messages via our <a href="{% url 'haystack_search' %}">search page</a>.
</p>
{% include "ygroup/pagination.html" %}
<table>
   <tr><th>Title</th><th>Author</th><th>Posts</th><th>Date</th></tr>
   {% for thread in page_obj.object_list %}
   <tr>
      <td><a href="{{ thread.get_absolute_url }}">{{ thread.title }}</a></td>
      <td>{{ thread.poster }}</td>
      <td>{{ thread.post_count }}</td>
      <td>{{ thread.creation_date|date:"d M Y" }}</td>
   </tr>
   {% endfor %}
</table>
{% include "ygroup/pagination.html" %}
{% endblock %}