details: https://code.openbravo.com/erp/devel/pi/rev/e22dd1199630
changeset: 21084:e22dd1199630
user: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
date: Thu Sep 05 12:28:10 2013 +0530
summary: Fixes Issue 0024694: Added index to m_product to improve simple
product selector performance
Added index m_product_gen_prod for m_product table.
diffstat:
src-db/database/model/tables/M_PRODUCT.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r b0088df35300 -r e22dd1199630 src-db/database/model/tables/M_PRODUCT.xml
--- a/src-db/database/model/tables/M_PRODUCT.xml Thu Sep 05 08:35:50
2013 +0200
+++ b/src-db/database/model/tables/M_PRODUCT.xml Thu Sep 05 12:28:10
2013 +0530
@@ -419,6 +419,9 @@
<index name="M_PRODUCT_BPARTNER" unique="false">
<index-column name="C_BPARTNER_ID"/>
</index>
+ <index name="M_PRODUCT_GEN_PROD" unique="false">
+ <index-column name="GENERIC_PRODUCT_ID"/>
+ </index>
<index name="M_PRODUCT_NAME" unique="false">
<index-column name="NAME"/>
</index>
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
