[CalendarServer-changes] [6892] CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql
source_changes at macosforge.org
source_changes at macosforge.org
Sat Feb 5 09:56:23 PST 2011
Revision: 6892
http://trac.macosforge.org/projects/calendarserver/changeset/6892
Author: cdaboo at apple.com
Date: 2011-02-05 09:56:22 -0800 (Sat, 05 Feb 2011)
Log Message:
-----------
Add an index to improve one of the longer queries.
Modified Paths:
--------------
CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql
Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql 2011-02-05 17:39:52 UTC (rev 6891)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql 2011-02-05 17:56:22 UTC (rev 6892)
@@ -196,8 +196,11 @@
create index CALENDAR_OBJECT_CALENDAR_RESOURCE_ID_AND_ICALENDAR_UID on
CALENDAR_OBJECT(CALENDAR_RESOURCE_ID, ICALENDAR_UID);
+
+create index CALENDAR_OBJECT_CALENDAR_RESOURCE_ID_RECURRANCE_MAX on
+ CALENDAR_OBJECT(CALENDAR_RESOURCE_ID, RECURRANCE_MAX);
-create index CALENDAR_OBJECT_ORGANIZER_OBJECT on
+ create index CALENDAR_OBJECT_ORGANIZER_OBJECT on
CALENDAR_OBJECT(ORGANIZER_OBJECT);
create index CALENDAR_OBJECT_DROPBOX_ID on
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20110205/5c89c2b0/attachment.html>
More information about the calendarserver-changes
mailing list