diff options
| author | Dan McGee <dan@archlinux.org> | 2010-10-05 00:37:39 +0200 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2010-10-05 00:37:39 +0200 |
| commit | 11f0db759bb04d0dce303de91c6df441cdf0bfee (patch) | |
| tree | b7f76309cba6ef20587040672be5ed6684d6bdc4 | |
| parent | 0e58a2e49f59fe41a27afa7bf8f9b3c77405c6d1 (diff) | |
| download | archweb-11f0db759bb04d0dce303de91c6df441cdf0bfee.tar.gz archweb-11f0db759bb04d0dce303de91c6df441cdf0bfee.tar.xz | |
Add some select_related() magic
Made obvious when poking around with the Django debug toolbar.
Signed-off-by: Dan McGee <dan@archlinux.org>
| -rw-r--r-- | packages/utils.py | 2 | ||||
| -rw-r--r-- | 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 ) |