view gpp/templates/forums/forum_query.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 c374bfd5594f
children
line wrap: on
line source
{% load url from future %}
<form action="." method="get" id="forum-query-form">
   <select id="forum-query-select">
      {% if user.is_authenticated %}
      <option value="{% url 'forums-unread_topics' %}">Show topics with unread posts</option>
      {% endif %}
      <option value="{% url 'forums-active_topics' 30 %}">Show active topics</option>
      <option value="{% url 'forums-unanswered_topics' %}">Show unanswered topics</option>
      {% if user.is_authenticated %}
      <option value="{% url 'forums-my_posts' %}">Show my posts</option>
      <option value="{% url 'forums-manage_favorites' %}">Show my favorite topics</option>
      <option value="{% url 'forums-manage_subscriptions' %}">Show my subscribed topics</option>
      {% endif %}
   </select>
   <button type="button" id="forum-query-button">Go</button>
</form>