cvs: pearweb /sql bugs.sql pearweb_mdb2schema.xml users.sql

cellog          Thu Oct 19 04:16:37 2006 UTC

  Modified files:              
    /pearweb/sql        bugs.sql pearweb_mdb2schema.xml users.sql 
  Log:
  add index to bugdb_comments, users to dramatically speed up bug tracker query
  
http://cvs.php.net/viewvc.cgi/pearweb/sql/bugs.sql?r1=1.8&r2=1.9&diff_format=u
Index: pearweb/sql/bugs.sql
diff -u pearweb/sql/bugs.sql:1.8 pearweb/sql/bugs.sql:1.9
--- pearweb/sql/bugs.sql:1.8    Wed Jun 21 12:15:24 2006
+++ pearweb/sql/bugs.sql        Thu Oct 19 04:16:37 2006
@@ -34,7 +34,8 @@
   ts datetime NOT NULL default '0000-00-00 00:00:00',
   comment text NOT NULL,
   PRIMARY KEY  (id),
-  FULLTEXT KEY comment (comment)
+  FULLTEXT KEY comment (comment),
+  INDEX bug (bug, id, ts)
 ) TYPE=MyISAM;
 
 -- score's value can be 1 through 5
http://cvs.php.net/viewvc.cgi/pearweb/sql/pearweb_mdb2schema.xml?r1=1.8&r2=1.9&diff_format=u
Index: pearweb/sql/pearweb_mdb2schema.xml
diff -u pearweb/sql/pearweb_mdb2schema.xml:1.8 
pearweb/sql/pearweb_mdb2schema.xml:1.9
--- pearweb/sql/pearweb_mdb2schema.xml:1.8      Thu Oct 19 04:00:47 2006
+++ pearweb/sql/pearweb_mdb2schema.xml  Thu Oct 19 04:16:37 2006
@@ -327,6 +327,22 @@
     </field>
    </index>
 
+   <index>
+    <name>bug</name>
+    <field>
+     <name>bug</name>
+     <sorting>ascending</sorting>
+    </field>
+    <field>
+     <name>id</name>
+     <sorting>ascending</sorting>
+    </field>
+    <field>
+     <name>ts</name>
+     <sorting>ascending</sorting>
+    </field>
+   </index>
+
   </declaration>
 
  </table>
@@ -2146,6 +2162,15 @@
    </index>
 
    <index>
+    <name>email</name>
+    <field>
+     <name>email</name>
+     <sorting>descending</sorting>
+     <length>25</length>
+    </field>
+   </index>
+
+   <index>
     <name>primary</name>
     <primary>true</primary>
     <field>
http://cvs.php.net/viewvc.cgi/pearweb/sql/users.sql?r1=1.16&r2=1.17&diff_format=u
Index: pearweb/sql/users.sql
diff -u pearweb/sql/users.sql:1.16 pearweb/sql/users.sql:1.17
--- pearweb/sql/users.sql:1.16  Thu Oct 27 20:02:42 2005
+++ pearweb/sql/users.sql       Thu Oct 19 04:16:37 2006
@@ -16,7 +16,8 @@
   wishlist varchar(255) NOT NULL default '',
   PRIMARY KEY  (handle),
   KEY handle (handle,registered),
-  KEY pgpkeyid (pgpkeyid)
+  KEY pgpkeyid (pgpkeyid),
+  KEY email (email(25))
 );
 
 -- Password is "admin"

-- 
PEAR CVS Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php