Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047658Retail ModulesWeb POSpublic2021-09-08 22:032021-09-20 06:50
Reportermalsasua 
Assigned ToRetail 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047658: performance issue deleting an orderline with Merge Tickets module: new index is required
DescriptionWith 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff index.diff (698) 2021-09-08 22:03
https://issues.openbravo.com/file_download.php?file_id=16185&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-09-08 22:03malsasuaNew Issue
2021-09-08 22:03malsasuaAssigned To => Retail
2021-09-08 22:03malsasuaFile Added: index.diff
2021-09-08 22:03malsasuaOBNetwork customer => Gold
2021-09-08 22:03malsasuaTriggers an Emergency Pack => No
2021-09-20 06:50marvintmReview Assigned To => marvintm
2021-09-20 06:50marvintmNote Added: 0131912
2021-09-20 06:50marvintmStatusnew => closed
2021-09-20 06:50marvintmResolutionopen => no change required

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