From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Skf0V-0001dJ-Pi for garchives@archives.gentoo.org; Fri, 29 Jun 2012 17:29:24 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 82094E0262; Fri, 29 Jun 2012 17:29:13 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id 52100E0262 for ; Fri, 29 Jun 2012 17:29:13 +0000 (UTC) Received: from hornbill.gentoo.org (hornbill.gentoo.org [94.100.119.163]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTPS id 6DFC41B40A2 for ; Fri, 29 Jun 2012 17:29:12 +0000 (UTC) Received: from localhost.localdomain (localhost [127.0.0.1]) by hornbill.gentoo.org (Postfix) with ESMTP id 36ADAE5432 for ; Fri, 29 Jun 2012 17:29:11 +0000 (UTC) From: "Slava Bacherikov" To: gentoo-commits@lists.gentoo.org Content-type: text/plain; charset=UTF-8 Reply-To: gentoo-dev@lists.gentoo.org, "Slava Bacherikov" Message-ID: <1340929708.1534ff4c1ae792366ecdf5a426c55e32130a7722.bacher09@gentoo> Subject: [gentoo-commits] proj/gentoo-packages:master commit in: gpackages/apps/packages/ X-VCS-Repository: proj/gentoo-packages X-VCS-Files: gpackages/apps/packages/views.py X-VCS-Directories: gpackages/apps/packages/ X-VCS-Committer: bacher09 X-VCS-Committer-Name: Slava Bacherikov X-VCS-Revision: 1534ff4c1ae792366ecdf5a426c55e32130a7722 X-VCS-Branch: master Date: Fri, 29 Jun 2012 17:29:11 +0000 (UTC) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-commits@lists.gentoo.org Content-Transfer-Encoding: quoted-printable X-Archives-Salt: e3c75a56-4f29-40cc-8e2e-cd0e9283b921 X-Archives-Hash: f7920d0bd652f4271df04525e8d12696 commit: 1534ff4c1ae792366ecdf5a426c55e32130a7722 Author: Slava Bacherikov bacher09 org> AuthorDate: Fri Jun 29 00:28:28 2012 +0000 Commit: Slava Bacherikov bacherikov org ua> CommitDate: Fri Jun 29 00:28:28 2012 +0000 URL: http://git.overlays.gentoo.org/gitweb/?p=3Dproj/gentoo-packag= es.git;a=3Dcommit;h=3D1534ff4c Litle optimize queries --- gpackages/apps/packages/views.py | 22 ++++------------------ 1 files changed, 4 insertions(+), 18 deletions(-) diff --git a/gpackages/apps/packages/views.py b/gpackages/apps/packages/v= iews.py index 98672d4..3b4cd23 100644 --- a/gpackages/apps/packages/views.py +++ b/gpackages/apps/packages/views.py @@ -56,15 +56,8 @@ class PackagesListsView(ContextListView): context_object_name =3D 'packages' queryset =3D PackageModel.objects.all(). \ select_related('virtual_package', - 'virtual_package__category', - 'repository'). \ - defer('repository__description', - 'repository__owner_name', - 'repository__owner_email', - 'repository__homepage', - 'repository__official', - 'repository__quality', - 'changelog'). \ + 'virtual_package__category'). \ + prefetch_related('repository'). \ prefetch_keywords(arches) =20 class PackageDetailView(ContextView, DetailView): @@ -74,15 +67,8 @@ class PackageDetailView(ContextView, DetailView): context_object_name =3D 'package' queryset =3D PackageModel.objects.all(). \ select_related('virtual_package', - 'virtual_package__category', - 'repository'). \ - defer('repository__description', - 'repository__owner_name', - 'repository__owner_email', - 'repository__homepage', - 'repository__official', - 'repository__quality', - 'changelog'). \ + 'virtual_package__category'). \ + prefetch_related('repository'). \ prefetch_keywords(arches) =20 def get_object(self, queryset =3D None):