Mercurial > public > sg101
log gpp/forums/feeds.py @ 557:7247a406f92b
age | author | description |
---|---|---|
Wed, 07 Dec 2011 01:08:54 +0000 | Brian Neal | For #237, use Redis as the source of posts for the RSS feeds to hopefully eliminate some slow queries. |
Fri, 25 Mar 2011 00:39:17 +0000 | Brian Neal | Fixing grammar in a comment only. |
Thu, 24 Mar 2011 00:15:34 +0000 | Brian Neal | Another try at #191 after getting some good advice in a django-users thread. |
Wed, 23 Mar 2011 00:44:06 +0000 | Brian Neal | Another tweak to the forum feeds query; see #191. |
Sat, 19 Mar 2011 05:03:51 +0000 | Brian Neal | 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. |
Sat, 19 Mar 2011 01:52:41 +0000 | Brian Neal | Fixing #191; terrible performance on the combined forums RSS feed query. Use an .extra() clause to force the WHERE on a query to use the primary key. |