details: https://code.openbravo.com/erp/devel/pi/rev/de5ea8bf7fce
changeset: 34213:de5ea8bf7fce
user: Mark <markmm82 <at> gmail.com>
date: Thu Jun 14 19:20:21 2018 -0400
summary: Fixes issue 38772:Index on M_MATCHPO to improve performance in
Create Lines From
Caused by a query that is executed for every candidate order validating that
exists lines that can be
invoiced requesting information from M_MATCHPO, the Create Lines From process
on Invoice windows has
bad performance and to be improved waa needed to add a new index in
C_ORDERLINE_ID and C_INVOICELINE_ID
columns taking into account those records where C_INVOICELINE_ID IS NOT NULL.
diffstat:
src-db/database/model/tables/M_MATCHPO.xml | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diffs (15 lines):
diff -r 941c49187697 -r de5ea8bf7fce src-db/database/model/tables/M_MATCHPO.xml
--- a/src-db/database/model/tables/M_MATCHPO.xml Tue Jun 19 11:23:55
2018 +0000
+++ b/src-db/database/model/tables/M_MATCHPO.xml Thu Jun 14 19:20:21
2018 -0400
@@ -95,6 +95,11 @@
<index-column name="C_INVOICELINE_ID"/>
<whereClause><![CDATA[C_INVOICELINE_ID IS NOT NULL]]></whereClause>
</index>
+ <index name="M_MATCHPO_ORDLINE_INVLINE" unique="false">
+ <index-column name="C_ORDERLINE_ID"/>
+ <index-column name="C_INVOICELINE_ID"/>
+ <whereClause><![CDATA[C_INVOICELINE_ID IS NOT NULL]]></whereClause>
+ </index>
<index name="M_MATCHPO_POSTED" unique="false">
<index-column name="POSTED"/>
</index>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
