Changeset 7b57a9b for asadb/groups

Timestamp:

Aug 24, 2011, 10:32:14 PM (14 years ago)

Author:

Alex Dehnert <adehnert@…>

Branches:

master, space-access, stable, stage, test-hooks

Children:

9ea4909

Parents:

1de230f

git-author:

Alex Dehnert <adehnert@…> (08/24/11 22:32:14)

git-committer:

Alex Dehnert <adehnert@…> (08/24/11 22:32:14)

Message:

Optimize the signatory view

By using select_related, we can make generating the view several times faster

File:

• asadb/groups/views.py (modified) (2 diffs)

asadb/groups/views.py

@@ -20 +20 @@
 from django.forms import ModelForm
 from django.forms import ModelChoiceField
+from django.db import connection
 from django.db.models import Q
 
@@ -396 +397 @@
 
     officers = groups.models.OfficeHolder.objects.filter(start_time__lte=datetime.datetime.now(), end_time__gte=datetime.datetime.now())
+    officers = officers.select_related(depth=1)
     all_groups = groups.models.Group.objects.all()
     roles = groups.models.OfficerRole.objects.all()
     officers_map = collections.defaultdict(lambda: collections.defaultdict(set))
-    print officers
     for officer in officers:
         officers_map[officer.group][officer.role].add(officer.person)