[CalendarServer-changes] [2242] CalendarServer/trunk/twistedcaldav/directory/calendaruserproxy.py

[source_changes at macosforge.org]

Revision: 2242
          http://trac.macosforge.org/projects/calendarserver/changeset/2242
Author:   cdaboo at apple.com
Date:     2008-03-21 10:44:00 -0700 (Fri, 21 Mar 2008)

Log Message:
-----------
Index the proxy db for better performance.

Modified Paths:
--------------
    CalendarServer/trunk/twistedcaldav/directory/calendaruserproxy.py

Modified: CalendarServer/trunk/twistedcaldav/directory/calendaruserproxy.py
===================================================================
--- CalendarServer/trunk/twistedcaldav/directory/calendaruserproxy.py	2008-03-18 21:25:34 UTC (rev 2241)
+++ CalendarServer/trunk/twistedcaldav/directory/calendaruserproxy.py	2008-03-21 17:44:00 UTC (rev 2242)
@@ -411,6 +411,16 @@
             )
             """
         )
+        q.execute(
+            """
+            create index GROUPNAMES on GROUPS (GROUPNAME)
+            """
+        )
+        q.execute(
+            """
+            create index MEMBERS on GROUPS (MEMBER)
+            """
+        )
 
 ##
 # Utilities

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20080321/ccbdc2fe/attachment.html