details: https://code.openbravo.com/erp/devel/pi/rev/eaf73138f70a
changeset: 32672:eaf73138f70a
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue Sep 12 21:41:29 2017 +0530
summary: Fixes issue 36814: Customer Statement process takes long
Add index for c_bpartner_id column in fact_acct table
diffstat:
src-db/database/model/tables/FACT_ACCT.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r b78d862f32f3 -r eaf73138f70a src-db/database/model/tables/FACT_ACCT.xml
--- a/src-db/database/model/tables/FACT_ACCT.xml Tue Sep 12 13:15:31
2017 +0200
+++ b/src-db/database/model/tables/FACT_ACCT.xml Tue Sep 12 21:41:29
2017 +0530
@@ -292,6 +292,9 @@
<index-column name="C_ACCTSCHEMA_ID"/>
<index-column name="ACCOUNT_ID"/>
</index>
+ <index name="FACT_ACCT_BPARTNER" unique="false">
+ <index-column name="C_BPARTNER_ID"/>
+ </index>
<index name="FACT_ACCT_DATEACCT" unique="false">
<index-column name="DATEACCT"/>
</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
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
