cvs: pearweb /sql bugs.sql pearweb_mdb2schema.xml

cellog          Thu Oct 19 04:30:52 2006 UTC

  Modified files:              
    /pearweb/sql        bugs.sql pearweb_mdb2schema.xml 
  Log:
  add index to bugdb to dramatically speed up another bug tracker query
  
http://cvs.php.net/viewvc.cgi/pearweb/sql/bugs.sql?r1=1.9&r2=1.10&diff_format=u
Index: pearweb/sql/bugs.sql
diff -u pearweb/sql/bugs.sql:1.9 pearweb/sql/bugs.sql:1.10
--- pearweb/sql/bugs.sql:1.9    Thu Oct 19 04:16:37 2006
+++ pearweb/sql/bugs.sql        Thu Oct 19 04:30:52 2006
@@ -21,6 +21,7 @@
   PRIMARY KEY  (id),
   KEY php_version (php_version(1)),
   KEY package_version (package_version(1)),
+  KEY package_name(package_name),
   FULLTEXT KEY email (email,sdesc,ldesc)
 ) TYPE=MyISAM;
 
http://cvs.php.net/viewvc.cgi/pearweb/sql/pearweb_mdb2schema.xml?r1=1.9&r2=1.10&diff_format=u
Index: pearweb/sql/pearweb_mdb2schema.xml
diff -u pearweb/sql/pearweb_mdb2schema.xml:1.9 
pearweb/sql/pearweb_mdb2schema.xml:1.10
--- pearweb/sql/pearweb_mdb2schema.xml:1.9      Thu Oct 19 04:16:37 2006
+++ pearweb/sql/pearweb_mdb2schema.xml  Thu Oct 19 04:30:52 2006
@@ -228,6 +228,14 @@
    </index>
 
    <index>
+    <name>package_name</name>
+    <field>
+     <name>package_name</name>
+     <sorting>ascending</sorting>
+    </field>
+   </index>
+
+   <index>
     <name>email</name>
     <field>
      <name>email</name>

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