cvs: pearweb /sql deps.sql pearweb_mdb2schema.xml

cellog          Thu Oct 19 03:57:15 2006 UTC

  Modified files:              
    /pearweb/sql        deps.sql pearweb_mdb2schema.xml 
  Log:
  add index to deps to speed up slow query
  
http://cvs.php.net/viewvc.cgi/pearweb/sql/deps.sql?r1=1.7&r2=1.8&diff_format=u
Index: pearweb/sql/deps.sql
diff -u pearweb/sql/deps.sql:1.7 pearweb/sql/deps.sql:1.8
--- pearweb/sql/deps.sql:1.7    Wed Jul 21 14:33:13 2004
+++ pearweb/sql/deps.sql        Thu Oct 19 03:57:15 2006
@@ -12,5 +12,6 @@
   name varchar(100) NOT NULL default '',
   optional tinyint(4) NOT NULL default '0',
   KEY release (release),
-  KEY package (package,version)
+  KEY package (package,version),
+  KEY package_2 (package,optional)
 );
http://cvs.php.net/viewvc.cgi/pearweb/sql/pearweb_mdb2schema.xml?r1=1.6&r2=1.7&diff_format=u
Index: pearweb/sql/pearweb_mdb2schema.xml
diff -u pearweb/sql/pearweb_mdb2schema.xml:1.6 
pearweb/sql/pearweb_mdb2schema.xml:1.7
--- pearweb/sql/pearweb_mdb2schema.xml:1.6      Thu Oct 19 01:28:32 2006
+++ pearweb/sql/pearweb_mdb2schema.xml  Thu Oct 19 03:57:15 2006
@@ -851,6 +851,18 @@
     </field>
    </index>
 
+   <index>
+    <name>package</name>
+    <field>
+     <name>package</name>
+     <sorting>ascending</sorting>
+    </field>
+    <field>
+     <name>optional</name>
+     <sorting>ascending</sorting>
+    </field>
+   </index>
+
   </declaration>
 
  </table>

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