details: https://code.openbravo.com/erp/devel/pi/rev/2c5b66feedf4
changeset: 16746:2c5b66feedf4
user: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
date: Tue Jun 05 13:11:45 2012 +0200
summary: Related to issue 20551. Performance on Match Statement window
diffstat:
src-db/database/model/tables/FIN_FINACC_TRANSACTION.xml | 5 +++++
src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml | 3 +++
2 files changed, 8 insertions(+), 0 deletions(-)
diffs (28 lines):
diff -r f40da034b00f -r 2c5b66feedf4
src-db/database/model/tables/FIN_FINACC_TRANSACTION.xml
--- a/src-db/database/model/tables/FIN_FINACC_TRANSACTION.xml Thu May 31
17:34:22 2012 +0200
+++ b/src-db/database/model/tables/FIN_FINACC_TRANSACTION.xml Tue Jun 05
13:11:45 2012 +0200
@@ -187,6 +187,11 @@
<foreign-key foreignTable="FIN_PAYMENT" name="FIN_PAYMENT_TRANSACTION">
<reference local="FIN_PAYMENT_ID" foreign="FIN_PAYMENT_ID"/>
</foreign-key>
+ <index name="FIN_FINACC_TRANSACTION_DAO" unique="false">
+ <index-column name="FIN_FINANCIAL_ACCOUNT_ID"/>
+ <index-column name="FIN_RECONCILIATION_ID"/>
+ <index-column name="STATUS"/>
+ </index>
<unique name="FIN_FINACC_TRANSACTION_UN">
<unique-column name="FIN_PAYMENT_ID"/>
</unique>
diff -r f40da034b00f -r 2c5b66feedf4
src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml
--- a/src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml Thu May 31
17:34:22 2012 +0200
+++ b/src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml Tue Jun 05
13:11:45 2012 +0200
@@ -97,6 +97,9 @@
<index name="FIN_PAYM_SCH_INV_IDX" unique="false">
<index-column name="C_INVOICE_ID"/>
</index>
+ <index name="FIN_PAYMENT_SCHEDULE_OUTAMT" unique="false">
+ <index-column name="OUTSTANDINGAMT"/>
+ </index>
<check name="FIN_PAYSCHED_UPP_CHK"><![CDATA[UPDATE_PAYMENT_PLAN IN ('Y',
'N')]]></check>
</table>
</database>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
