Mercurial > public > sg101
annotate gpp/templates/core/pagination_query.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 | dbd703f7d63a |
| children |
| rev | line source |
|---|---|
| gremmie@1 | 1 <div class="pagination"> |
| gremmie@1 | 2 <ul> |
| gremmie@1 | 3 {% if page.has_previous %} |
| gremmie@1 | 4 <li class="prev"><a href="../{{ page.previous_page_number }}/?query={{ query }}" title="Go to page {{ page.previous_page_number }}">« Previous</a></li> |
| gremmie@1 | 5 {% endif %} |
| gremmie@1 | 6 {% for num in page.page_range %} |
| gremmie@1 | 7 {% if num %} |
| gremmie@1 | 8 {% ifequal num page.number %} |
| gremmie@1 | 9 <li class="current">{{ num }}</li> |
| gremmie@1 | 10 {% else %} |
| gremmie@1 | 11 <li class="page"><a href="../{{ num }}/?query={{ query }}" title="Go to page {{ num }}">{{ num }}</a></li> |
| gremmie@1 | 12 {% endifequal %} |
| gremmie@1 | 13 {% else %} |
| gremmie@1 | 14 <li>…</li> |
| gremmie@1 | 15 {% endif %} |
| gremmie@1 | 16 {% endfor %} |
| gremmie@1 | 17 {% if page.has_next %} |
| gremmie@1 | 18 <li class="next"><a href="../{{ page.next_page_number }}/?query={{ query }}" title="Go to page {{ page.next_page_number }}">Next »</a></li> |
| gremmie@1 | 19 {% endif %} |
| gremmie@1 | 20 </ul> |
| gremmie@1 | 21 </div> |
| gremmie@1 | 22 <br clear="left" /> |