view gpp/templates/downloads/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 88b2b9cb8c1f
children
line wrap: on
line source
{% extends 'base.html' %}
{% load url from future %}
{% load downloads_tags %}
{% block title %}Downloads{% endblock %}
{% block custom_css %}
<link rel="stylesheet" type="text/css" href="{{ STATIC_URL }}css/downloads.css" />
{% endblock %}
{% block content %}
<h2>Downloads</h2>
{% include 'downloads/navigation.html' %}
<h3>Categories</h3>
{% if categories %}
<p>We have {{ total_dls }} download{{ total_dls|pluralize }} in {{ categories.count }} categories.</p>
<dl>
{% for category in categories %}
<dt>
<a href="{% url 'downloads-category' slug=category.slug sort="title" %}">{{ category.title }}</a>
({{ category.count }})
</dt>
<dd><p>{{ category.description }}</p></dd>
{% endfor %}
</dl>
{% endif %}
{% endblock %}