[Erp5-report] r18126 - in /erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog: Ca...

[nobody at svn.erp5.org]

Author: vincent
Date: Fri Dec  7 15:50:26 2007
New Revision: 18126

URL: http://svn.erp5.org?rev=18126&view=rev
Log:
Replace node_uid index by a composite index on node_uid, simulation_state and date. This index is used by the WHERE expression in Resource_zGetTrackingList.

Modified:
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml
    erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml?rev=18126&r1=18125&r2=18126&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_item.xml Fri Dec  7 15:50:26 2007
@@ -102,11 +102,11 @@
   `variation_text` VARCHAR(255),\n
   `simulation_state` VARCHAR(255) default \'\',\n
   KEY `uid` (`uid`),\n
-  KEY `node_uid` (`node_uid`),\n
   KEY `section_uid` (`section_uid`),\n
   KEY `resource_uid` (`resource_uid`),\n
   KEY `variation_text` (`variation_text`),\n
-  KEY `aggregate_simulation_state_date` (`aggregate_uid`,`simulation_state`,`date`)\n
+  KEY `aggregate_simulation_state_date` (`aggregate_uid`,`simulation_state`,`date`),\n
+  KEY `node_simulation_state_date` (`node_uid`,`simulation_state`,`date`)\n
 ) TYPE=InnoDB;\n
 </string> </value>
         </item>
@@ -158,11 +158,11 @@
   `variation_text` VARCHAR(255),\n
   `simulation_state` VARCHAR(255) default \'\',\n
   KEY `uid` (`uid`),\n
-  KEY `node_uid` (`node_uid`),\n
   KEY `section_uid` (`section_uid`),\n
   KEY `resource_uid` (`resource_uid`),\n
   KEY `variation_text` (`variation_text`),\n
-  KEY `aggregate_simulation_state_date` (`aggregate_uid`,`simulation_state`,`date`)\n
+  KEY `aggregate_simulation_state_date` (`aggregate_uid`,`simulation_state`,`date`),\n
+  KEY `node_simulation_state_date` (`node_uid`,`simulation_state`,`date`)\n
 ) TYPE=InnoDB;\n
 </string> </value>
                     </item>

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision?rev=18126&r1=18125&r2=18126&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision Fri Dec  7 15:50:26 2007
@@ -1,1 +1,1 @@
-86
+87