details: http://code.openbravo.com/erp/devel/pi/rev/27857f98b2e3
changeset: 3279:27857f98b2e3
user: Stefan Hühner <stefan.hueh...@openbravo.com>
date: Mon Mar 02 17:17:25 2009 +0100
description:
Fixed 7898: fixed slow Product selector performance when using BOM
adds missing index to speed up BOM_PRICE{LIST,LIMIT,STD} functions which are
used in the selector
diffs (13 lines):
diff -r 9a161c2aed33 -r 27857f98b2e3
src-db/database/model/tables/M_PRODUCT_BOM.xml
--- a/src-db/database/model/tables/M_PRODUCT_BOM.xml Mon Mar 02 17:08:12
2009 +0100
+++ b/src-db/database/model/tables/M_PRODUCT_BOM.xml Mon Mar 02 17:17:25
2009 +0100
@@ -69,6 +69,9 @@
<foreign-key foreignTable="M_PRODUCT" name="MPRODUCT_MPRODUCTBOM"
onDelete="cascade">
<reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
</foreign-key>
+ <index name="M_PRODUCT_BOM_M_PRODUCT_ID" unique="false">
+ <index-column name="M_PRODUCT_ID"/>
+ </index>
<check name="M_PRODUCT_BOM_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
</table>
</database>
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
