cvs: pearweb /sql pearweb_mdb2schema.xml releases.sql

cellog          Thu Oct 19 04:00:47 2006 UTC

  Modified files:              
    /pearweb/sql        pearweb_mdb2schema.xml releases.sql 
  Log:
  add index to releases to speed up slow query
  
http://cvs.php.net/viewvc.cgi/pearweb/sql/pearweb_mdb2schema.xml?r1=1.7&r2=1.8&diff_format=u
Index: pearweb/sql/pearweb_mdb2schema.xml
diff -u pearweb/sql/pearweb_mdb2schema.xml:1.7 
pearweb/sql/pearweb_mdb2schema.xml:1.8
--- pearweb/sql/pearweb_mdb2schema.xml:1.7      Thu Oct 19 03:57:15 2006
+++ pearweb/sql/pearweb_mdb2schema.xml  Thu Oct 19 04:00:47 2006
@@ -1917,6 +1917,19 @@
     </field>
    </index>
 
+   <index>
+    <name>package</name>
+    <unique>true</unique>
+    <field>
+     <name>releasedate</name>
+     <sorting>ascending</sorting>
+    </field>
+    <field>
+     <name>package</name>
+     <sorting>ascending</sorting>
+    </field>
+   </index>
+
   </declaration>
 
  </table>
http://cvs.php.net/viewvc.cgi/pearweb/sql/releases.sql?r1=1.12&r2=1.13&diff_format=u
Index: pearweb/sql/releases.sql
diff -u pearweb/sql/releases.sql:1.12 pearweb/sql/releases.sql:1.13
--- pearweb/sql/releases.sql:1.12       Wed Jul 21 14:33:13 2004
+++ pearweb/sql/releases.sql    Thu Oct 19 04:00:47 2006
@@ -16,5 +16,6 @@
   releasenotes text,
   PRIMARY KEY  (id),
   UNIQUE KEY package (package,version),
+  KEY releasedate (releasedate,package),
   KEY state (state)
 );