0047658: performance issue deleting an orderline with Merge Tickets module: new index is required

Description

With the merge tickets module and environments with a big volume of data, the time to delete an orderline is very high.

The problem is the column EM_OBMTR_LAYAWAY_LINE_ID in c_orderline table, that it is not indexed

Steps To Reproduce

. environment with a big volume of data
. create one orderline
. delete it

Tags

No tags attached.

Attached Files

index.diff [^] (698 bytes) 2021-09-08 22:03 [Show Content] [Hide Content]

diff --git a/src-db/database/model/modifiedTables/C_ORDERLINE.xml b/src-db/database/model/modifiedTables/C_ORDERLINE.xml
index 934b4332a4eb6bc7dcfde1feefd7300a8bec047d..8586b7cebf5641a13ea12fe586f187ed05657299 100644
--- a/src-db/database/model/modifiedTables/C_ORDERLINE.xml
+++ b/src-db/database/model/modifiedTables/C_ORDERLINE.xml
@@ -8,5 +8,8 @@
       <foreign-key foreignTable="C_ORDERLINE" name="EM_OBMTR_LAYAWAYLINE_ID">
         <reference local="EM_OBMTR_LAYAWAY_LINE_ID" foreign="C_ORDERLINE_ID"/>
       </foreign-key>
+      <index name="EM_OBMTR_ORDERLINE_LAYAWAY" unique="false">
+        <index-column name="EM_OBMTR_LAYAWAY_LINE_ID"/>
+      </index>
     </table>
   </database>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0131912) marvintm (developer) 2021-09-20 06:50	This functionality is not contributed. Ideally, this index should be added to it before it is contributed.

Issue History
Date Modified	Username	Field	Change
2021-09-08 22:03	malsasua	New Issue
2021-09-08 22:03	malsasua	Assigned To	=> Retail
2021-09-08 22:03	malsasua	File Added: index.diff
2021-09-08 22:03	malsasua	Triggers an Emergency Pack	=> No
2021-09-20 06:50	marvintm	Review Assigned To	=> marvintm
2021-09-20 06:50	marvintm	Note Added: 0131912
2021-09-20 06:50	marvintm	Status	new => closed
2021-09-20 06:50	marvintm	Resolution	open => no change required