From 11f0db759bb04d0dce303de91c6df441cdf0bfee Mon Sep 17 00:00:00 2001 From: Dan McGee Date: Mon, 4 Oct 2010 17:37:39 -0500 Subject: Add some select_related() magic Made obvious when poking around with the Django debug toolbar. Signed-off-by: Dan McGee --- packages/utils.py | 2 +- public/views.py | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/packages/utils.py b/packages/utils.py index 55b7acf..93d0de7 100644 --- a/packages/utils.py +++ b/packages/utils.py @@ -104,7 +104,7 @@ SELECT p.id, q.id # column A will always have a value, column B might be NULL to_fetch.append(row[0]) # fetch all of the necessary packages - pkgs = Package.objects.in_bulk(to_fetch) + pkgs = Package.objects.select_related('arch', 'repo').in_bulk(to_fetch) # now build a list of tuples containing differences differences = [] for row in results: diff --git a/public/views.py b/public/views.py index 4306774..6fbb689 100644 --- a/public/views.py +++ b/public/views.py @@ -43,7 +43,7 @@ def donate(request): return direct_to_template(request, 'public/donate.html', context) def download(request): - qset = MirrorUrl.objects.filter( + qset = MirrorUrl.objects.select_related('mirror', 'protocol').filter( Q(protocol__protocol__iexact='HTTP') | Q(protocol__protocol__iexact='FTP'), mirror__public=True, mirror__active=True, mirror__isos=True ) -- cgit v1.2.3-24-g4f1b