From 073a04bb6bc6555ebdafb8d18325a4a84d25b8c0 Mon Sep 17 00:00:00 2001 From: Jelle van der Waa Date: Thu, 28 Feb 2019 21:54:57 +0100 Subject: releng: reduce SELECT's for archlinux.ipxe request Only querying the required fields makes the code smaller and 20% faster on Sqlite. Signed-off-by: Jelle van der Waa --- releng/views.py | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/releng/views.py b/releng/views.py index f40ed666..f5fd708d 100644 --- a/releng/views.py +++ b/releng/views.py @@ -72,8 +72,7 @@ def releases_json(request): return response def netboot_config(request): - release_qs = Release.objects.filter(available=True).order_by('-release_date') - releases = [release.version for release in release_qs] + releases = Release.objects.filter(available=True).values_list('version', flat=True).order_by('-release_date') mirrorurls = MirrorUrl.objects.filter(protocol__protocol='http', active=True, mirror__public=True, -- cgit v1.2.3-55-g3dc8