details: https://code.openbravo.com/erp/devel/pi/rev/13f7a8be3163
changeset: 30309:13f7a8be3163
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Wed Sep 21 00:20:58 2016 +0530
summary: Fixes issue 33956: The generate invoice takes long with big amount
of data
Added index for column isselected of order table to improve select query and
initupdate method used in invoice create process.
diffstat:
src-db/database/model/tables/C_ORDER.xml | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diffs (13 lines):
diff -r ed3d9ac528b1 -r 13f7a8be3163 src-db/database/model/tables/C_ORDER.xml
--- a/src-db/database/model/tables/C_ORDER.xml Wed Sep 21 18:18:53 2016 +0200
+++ b/src-db/database/model/tables/C_ORDER.xml Wed Sep 21 00:20:58 2016 +0530
@@ -487,6 +487,9 @@
<index-column name="DOCUMENTNO"/>
<index-column name="C_ORDER_ID"/>
</index>
+ <index name="C_ORDER_ISSELECTED" unique="false">
+ <index-column name="ISSELECTED"/>
+ </index>
<index name="C_ORDER_POSTED" unique="false">
<index-column name="POSTED"/>
</index>
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
