db-setup.sqlite.patch   [plain text]

--- /tmp/jabberd-2.2.13/tools/db-setup.sqlite	2011-02-23 08:24:34.000000000 -0800
+++ ./jabberd2/tools/db-setup.sqlite	2011-02-24 16:25:21.000000000 -0800
@@ -52,6 +52,11 @@ CREATE TABLE "roster-items" (
 
 CREATE INDEX i_rosteri_owner ON "roster-items"("collection-owner");
 
+---
+--- Apple index to speed up jabber_autobuddy operations (still necessary in jabberd 2.2, with i_rosteri_owner added?)
+---
+CREATE INDEX "roster-items-owner-jid-index" on "roster-items" ("collection-owner", "jid");
+
 --
 -- Roster groups
 -- Used by: mod_roster
@@ -149,6 +154,8 @@ CREATE TABLE "vcard" (
     
     "rev" TEXT );
 
+CREATE INDEX i_vcard_owner ON "vcard"("collection-owner");
+
 --
 -- Offline message queue
 -- Used by: mod_offline