details: https://code.openbravo.com/erp/devel/pi/rev/f8cf0b0e4dc0
changeset: 31781:f8cf0b0e4dc0
user: Mark <markmm82 <at> gmail.com>
date: Mon Apr 03 09:41:35 2017 -0400
summary: Fixes issue 35210: Sequential scans in c_bpartner using BP selector
filter
Created trgm indexes on bp name and bp value column to improve the performance
when business partner selector is filtered using drop down list.
diffstat:
src-db/database/model/tables/C_BPARTNER.xml | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diffs (23 lines):
diff -r bd98803e01b5 -r f8cf0b0e4dc0 src-db/database/model/tables/C_BPARTNER.xml
--- a/src-db/database/model/tables/C_BPARTNER.xml Fri Mar 31 13:58:32
2017 -0400
+++ b/src-db/database/model/tables/C_BPARTNER.xml Mon Apr 03 09:41:35
2017 -0400
@@ -468,6 +468,9 @@
<index-column name="NAME"/>
<index-column name="C_BPARTNER_ID"/>
</index>
+ <index name="C_BPARTNER_NAME_TRGM" unique="false" containsSearch="true">
+ <index-column name="functionBasedColumn"
functionExpression="UPPER(NAME)"/>
+ </index>
<index name="C_BPARTNER_REFNO_ID" unique="false">
<index-column name="REFERENCENO"/>
<index-column name="C_BPARTNER_ID"/>
@@ -477,6 +480,9 @@
<index-column name="VALUE"/>
<index-column name="C_BPARTNER_ID"/>
</index>
+ <index name="C_BPARTNER_VALUE_TRGM" unique="false" containsSearch="true">
+ <index-column name="functionBasedColumn"
functionExpression="UPPER(VALUE)"/>
+ </index>
<unique name="C_BPARTNER_VALUE">
<unique-column name="AD_CLIENT_ID"/>
<unique-column name="AD_ORG_ID"/>
------------------------------------------------------------------------------
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
