annotate 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 |
|
| rev |
line source |
|
bgneal@310
|
1 {% load url from future %}
|
|
bgneal@280
|
2 <form action="." method="get" id="forum-query-form">
|
|
bgneal@280
|
3 <select id="forum-query-select">
|
|
bgneal@409
|
4 {% if user.is_authenticated %}
|
|
bgneal@310
|
5 <option value="{% url 'forums-unread_topics' %}">Show topics with unread posts</option>
|
|
bgneal@409
|
6 {% endif %}
|
|
bgneal@409
|
7 <option value="{% url 'forums-active_topics' 30 %}">Show active topics</option>
|
|
bgneal@310
|
8 <option value="{% url 'forums-unanswered_topics' %}">Show unanswered topics</option>
|
|
bgneal@280
|
9 {% if user.is_authenticated %}
|
|
bgneal@310
|
10 <option value="{% url 'forums-my_posts' %}">Show my posts</option>
|
|
bgneal@310
|
11 <option value="{% url 'forums-manage_favorites' %}">Show my favorite topics</option>
|
|
bgneal@310
|
12 <option value="{% url 'forums-manage_subscriptions' %}">Show my subscribed topics</option>
|
|
bgneal@280
|
13 {% endif %}
|
|
bgneal@280
|
14 </select>
|
|
bgneal@280
|
15 <button type="button" id="forum-query-button">Go</button>
|
|
bgneal@280
|
16 </form>
|
