annotate gpp/templates/weblinks/index.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 daa2916f5b34
children
rev   line source
gremmie@1 1 {% extends 'weblinks/base.html' %}
bgneal@310 2 {% load url from future %}
gremmie@1 3 {% block title %}Web Links{% endblock %}
gremmie@1 4 {% block weblinks_content %}
gremmie@1 5 <h3>Categories</h3>
gremmie@1 6 {% if categories %}
gremmie@1 7 <p>We have {{ total_links }} links in {{ categories.count }} categories.</p>
gremmie@1 8 <dl>
gremmie@1 9 {% for category in categories %}
bgneal@310 10 <dt><a href="{% url 'weblinks-view_links' slug=category.slug sort="title" %}">{{ category.title }}</a>
bgneal@193 11 ({{ category.count }})</dt>
gremmie@1 12 <dd><p>{{ category.description }}</p></dd>
gremmie@1 13 {% endfor %}
gremmie@1 14 </dl>
gremmie@1 15 {% endif %}
gremmie@1 16 {% endblock %}