diff options
| author | Maksudul Haque <saad.mk112@gmail.com> | 2022-10-29 19:11:52 +0600 |
|---|---|---|
| committer | Paolo Melchiorre <paolo@melchiorre.org> | 2022-11-07 17:24:15 +0100 |
| commit | 658dab210d38d9234abab20d97dc2f5e6cb3059c (patch) | |
| tree | bcc4e2be470bd029815cc6e289fc1b8a2a6952ed /aggregator | |
| parent | 33093f2ebf2c2ceabbbe301ed238ebad1706f3b9 (diff) | |
Fix N+1 Query on Feed List Page
Diffstat (limited to 'aggregator')
| -rw-r--r-- | aggregator/views.py | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/aggregator/views.py b/aggregator/views.py index c4ebae3e..a22e5dad 100644 --- a/aggregator/views.py +++ b/aggregator/views.py @@ -43,8 +43,13 @@ class FeedListView(ListView): paginate_by = 25 def get_queryset(self): - self.feed_type = get_object_or_404(FeedType, slug=self.kwargs.pop('feed_type_slug')) - return FeedItem.objects.filter(feed__feed_type=self.feed_type, feed__approval_status=APPROVED_FEED) + self.feed_type = get_object_or_404( + FeedType, slug=self.kwargs.pop('feed_type_slug') + ) + return FeedItem.objects.filter( + feed__feed_type=self.feed_type, + feed__approval_status=APPROVED_FEED + ).select_related('feed') def get_context_data(self, **kwargs): context = super().get_context_data(**kwargs) |