details: https://code.openbravo.com/erp/devel/pi/rev/72f923b76be5 changeset: 33545:72f923b76be5 user: Mark <markmm82 <at> gmail.com> date: Fri Feb 16 13:08:17 2018 -0500 summary: Fixes issue 37885:Performance issue in Physical Inventory when deleting a record with too many lines
To improve the performance when deleting inventory records with too many lines was added a new index on RELATEDINVENTORYLINEID column of M_INVENTORYLINE_INVENTORYLINE table for those not null diffstat: src-db/database/model/tables/M_INVENTORYLINE.xml | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diffs (14 lines): diff -r a959a97929c7 -r 72f923b76be5 src-db/database/model/tables/M_INVENTORYLINE.xml --- a/src-db/database/model/tables/M_INVENTORYLINE.xml Wed Feb 21 10:20:19 2018 -0500 +++ b/src-db/database/model/tables/M_INVENTORYLINE.xml Fri Feb 16 13:08:17 2018 -0500 @@ -119,6 +119,10 @@ <index name="M_INVENTORYLINE_INVENTORY" unique="false"> <index-column name="M_INVENTORY_ID"/> </index> + <index name="M_INVENTORYLINE_INVENTORYLINE" unique="false"> + <index-column name="RELATEDINVENTORYLINEID"/> + <whereClause><![CDATA[RELATEDINVENTORYLINEID IS NOT NULL]]></whereClause> + </index> <index name="M_INVENTORYLINE_PRODUCT" unique="false"> <index-column name="M_PRODUCT_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