Mercurial > public > sg101
annotate gpp/templates/weblinks/index.html @ 388:c3231af55778
For #191; r410 is wrong: it is returning the wrong posts. Rework. MySQL is not using an index on our query, and it is taking 10+ seconds. Replace this slow query with a loop that loops over the public forums, then sorts and returns the posts.
| author | Brian Neal <bgneal@gmail.com> |
|---|---|
| date | Sat, 19 Mar 2011 05:03:51 +0000 |
| 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 %} |