details: https://code.openbravo.com/erp/devel/pi/rev/7107f4841d8d changeset: 32530:7107f4841d8d user: Armaignac <collazoandy4 <at> gmail.com> date: Tue Aug 01 11:59:06 2017 -0400 summary: Fixes issue 32205: Deleting a line on the order line window takes long
Three new partial indexes were created to improve the performance on a huge enviroment. details: https://code.openbravo.com/erp/devel/pi/rev/8cb1e05233d4 changeset: 32531:8cb1e05233d4 user: Armaignac <collazoandy4 <at> gmail.com> date: Tue Aug 01 12:07:16 2017 -0400 summary: Fixes issue 32677: Deleting a line on the shipment/receipt line tab takes long When deleting a line on the shipment/receipt takes more than 1 minute on enviroment with big amount of data. Two new partial indexes were created to improve the performance on a huge enviroment. details: https://code.openbravo.com/erp/devel/pi/rev/9732bf05ed79 changeset: 32532:9732bf05ed79 user: Armaignac <collazoandy4 <at> gmail.com> date: Wed Aug 02 19:28:53 2017 -0400 summary: Fixes issue 36560: Shipment accounting date different than order movement date The m_inout_create process now set as accounting date the date get from the pos order or now if not. diffstat: src-db/database/model/functions/M_INOUT_CREATE.xml | 2 +- src-db/database/model/tables/C_ORDERLINE.xml | 12 ++++++++++++ src-db/database/model/tables/M_INOUTLINE.xml | 8 ++++++++ 3 files changed, 21 insertions(+), 1 deletions(-) diffs (59 lines): diff -r 5c0c3e9c06ff -r 9732bf05ed79 src-db/database/model/functions/M_INOUT_CREATE.xml --- a/src-db/database/model/functions/M_INOUT_CREATE.xml Thu Aug 03 16:48:09 2017 +0530 +++ b/src-db/database/model/functions/M_INOUT_CREATE.xml Wed Aug 02 19:28:53 2017 -0400 @@ -404,7 +404,7 @@ Cur_Order.AD_Org_ID, 'Y', now(), v_User_ID, now(), v_User_ID, v_DocumentNo, v_DocType_ID, Cur_Order.Description, 'N', 'C-', v_NEWORDERDATE, - TRUNC(now()), Cur_Order.C_BPartner_ID, Cur_Order.C_BPartner_Location_ID, Cur_Order.AD_User_ID, + v_NEWORDERDATE, Cur_Order.C_BPartner_ID, Cur_Order.C_BPartner_Location_ID, Cur_Order.AD_User_ID, Cur_Order.M_Warehouse_ID, Cur_Order.POReference, Cur_Order.DateOrdered, v_DeliveryRule, Cur_Order.FreightCostRule, Cur_Order.FreightAmt, Cur_Order.C_Project_ID, Cur_Order.C_Activity_ID, Cur_Order.C_Campaign_ID, Cur_Order.AD_OrgTrx_ID, Cur_Order.User1_ID, Cur_Order.User2_ID, diff -r 5c0c3e9c06ff -r 9732bf05ed79 src-db/database/model/tables/C_ORDERLINE.xml --- a/src-db/database/model/tables/C_ORDERLINE.xml Thu Aug 03 16:48:09 2017 +0530 +++ b/src-db/database/model/tables/C_ORDERLINE.xml Wed Aug 02 19:28:53 2017 -0400 @@ -380,6 +380,10 @@ <foreign-key foreignTable="M_WAREHOUSE_RULE" name="C_ORDERLINE_WAREHOUSERULE"> <reference local="M_WAREHOUSE_RULE_ID" foreign="M_WAREHOUSE_RULE_ID"/> </foreign-key> + <index name="C_ORDERLINE_BOMPARENT" unique="false"> + <index-column name="BOM_PARENT_ID"/> + <whereClause><![CDATA[BOM_PARENT_ID IS NOT NULL]]></whereClause> + </index> <index name="C_ORDERLINE_C_RETURN_REASON" unique="false"> <index-column name="C_RETURN_REASON_ID"/> <whereClause><![CDATA[C_RETURN_REASON_ID IS NOT NULL]]></whereClause> @@ -394,6 +398,14 @@ <index name="C_ORDERLINE_PRODUCT" unique="false"> <index-column name="M_PRODUCT_ID"/> </index> + <index name="C_ORDERLINE_QUOTATIONLINE" unique="false"> + <index-column name="QUOTATIONLINE_ID"/> + <whereClause><![CDATA[QUOTATIONLINE_ID IS NOT NULL]]></whereClause> + </index> + <index name="C_ORDERLINE_REFORDERLINE" unique="false"> + <index-column name="REF_ORDERLINE_ID"/> + <whereClause><![CDATA[REF_ORDERLINE_ID IS NOT NULL]]></whereClause> + </index> <check name="C_ORDERLINE_CHECK1"><![CDATA[QUANTITYORDER IS NULL AND M_PRODUCT_UOM_ID IS NULL OR QUANTITYORDER IS NOT NULL AND M_PRODUCT_UOM_ID IS NOT NULL]]></check> <check name="C_ORDERLINE_CHECK2"><![CDATA[LINENETAMT = 0 OR C_TAX_ID IS NOT NULL]]></check> <check name="C_ORDERLINE_DIRECTSHIP_CHECK"><![CDATA[DIRECTSHIP IN ('Y', 'N')]]></check> diff -r 5c0c3e9c06ff -r 9732bf05ed79 src-db/database/model/tables/M_INOUTLINE.xml --- a/src-db/database/model/tables/M_INOUTLINE.xml Thu Aug 03 16:48:09 2017 +0530 +++ b/src-db/database/model/tables/M_INOUTLINE.xml Wed Aug 02 19:28:53 2017 -0400 @@ -194,6 +194,14 @@ <foreign-key foreignTable="USER2" name="M_INOUTLINE_USER2"> <reference local="USER2_ID" foreign="USER2_ID"/> </foreign-key> + <index name="M_INOUTLINE_BOMPARENT" unique="false"> + <index-column name="BOM_PARENT_ID"/> + <whereClause><![CDATA[BOM_PARENT_ID IS NOT NULL]]></whereClause> + </index> + <index name="M_INOUTLINE_CANCELEDINOUTLINE" unique="false"> + <index-column name="CANCELED_INOUTLINE_ID"/> + <whereClause><![CDATA[CANCELED_INOUTLINE_ID IS NOT NULL]]></whereClause> + </index> <index name="M_INOUTLINE_INOUT" unique="false"> <index-column name="M_INOUT_ID"/> </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 Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
