Mercurial > public > sg101
diff gpp/forums/admin.py @ 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 | 79d454ff2de0 |
| children | 98b373ca09f3 |
line wrap: on
line diff
--- a/gpp/forums/admin.py Tue Jan 17 18:30:41 2012 -0600 +++ b/gpp/forums/admin.py Wed Jan 25 20:07:03 2012 -0600 @@ -40,7 +40,7 @@ class PostAdmin(admin.ModelAdmin): - list_display = ('topic', 'user', 'creation_date', 'update_date', 'summary') + list_display = ('user', 'creation_date', 'update_date', 'user_ip', 'summary') raw_id_fields = ('topic', 'user', ) exclude = ('html', ) search_fields = ('body', ) @@ -49,6 +49,9 @@ ordering = ('-creation_date', ) save_on_top = True + def queryset(self, request): + return Post.objects.select_related('user') + class FlaggedPostAdmin(admin.ModelAdmin): list_display = ['__unicode__', 'flag_date', 'get_post_url']