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
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
