details: https://code.openbravo.com/erp/devel/pi/rev/c73830693d65
changeset: 21930:c73830693d65
user: Stefan Hühner <stefan.huehner <at> openbravo.com>
date: Fri Feb 07 12:56:56 2014 +0100
summary: Fixed 25682: Add index on c_invoice.c_order_id to speedup triggers
c_order_trg & c_order_trg2
diffstat:
src-db/database/model/tables/C_INVOICE.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r 4ddcfa6e2e4c -r c73830693d65 src-db/database/model/tables/C_INVOICE.xml
--- a/src-db/database/model/tables/C_INVOICE.xml Fri Feb 07 12:53:48
2014 +0100
+++ b/src-db/database/model/tables/C_INVOICE.xml Fri Feb 07 12:56:56
2014 +0100
@@ -357,6 +357,9 @@
<index name="C_INVOICE_DOCNO" unique="false">
<index-column name="DOCUMENTNO"/>
</index>
+ <index name="C_INVOICE_ORDER" unique="false">
+ <index-column name="C_ORDER_ID"/>
+ </index>
<index name="C_INVOICE_UPDATED" unique="false">
<index-column name="UPDATED"/>
</index>
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
