[Erp5-report] r24165 - /erp5/trunk/products/CMFActivity/skins/activity/

[nobody at svn.erp5.org]

Author: vincent
Date: Tue Oct 14 10:11:14 2008
New Revision: 24165

URL: http://svn.erp5.org?rev=24165&view=rev
Log:
Fix bad query execution plan when executing SQL{Dict,Queue}_validateMessageList.

serialization_tag is checked for equality, but processing_node is checked for inequality.
So the right index column order is serialization_tag then processing_node.
serialization_tag is not used in a where-expression in any other zsqlmethod, so previous index can be removed to save space and insertion speed.

Modified:
    erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql
    erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql?rev=24165&r1=24164&r2=24165&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql Tue Oct 14 10:11:14 2008
@@ -28,7 +28,7 @@
   KEY (`method_id`),
   KEY `processing_node_processing` (`processing_node`, `processing`),
   KEY `processing_node_date` (`processing_node`, `date`),
-  KEY `processing_node_serialization_tag` (`processing_node`, `serialization_tag`),
+  KEY `serialization_tag_processing_node` (`serialization_tag`, `processing_node`),
   KEY (`priority`),
   KEY (`tag`),
   KEY (`order_validation_text`)

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql?rev=24165&r1=24164&r2=24165&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql Tue Oct 14 10:11:14 2008
@@ -25,7 +25,7 @@
   KEY (`method_id`),
   KEY `processing_node_processing` (`processing_node`, `processing`),
   KEY `processing_node_date` (`processing_node`, `date`),
-  KEY `processing_node_serialization_tag` (`processing_node`, `serialization_tag`),
+  KEY `serialization_tag_processing_node` (`serialization_tag`, `processing_node`),
   KEY (`priority`),
   KEY (`tag`)
 ) TYPE = InnoDB;