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