Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0047658 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | major | always | 2021-09-08 22:03 | 2021-09-20 06:50 | |||
Reporter | malsasua | View Status | public | |||||
Assigned To | Retail | |||||||
Priority | normal | Resolution | no change required | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | marvintm | |||||||
OBNetwork customer | Gold | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 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 | ![]() | |||||||
![]() |
|
![]() |
|
(0131912) marvintm (viewer) 2021-09-20 06:50 |
This functionality is not contributed. Ideally, this index should be added to it before it is contributed. |
![]() |
|||
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 | OBNetwork customer | => Gold |
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 |
Copyright © 2000 - 2009 MantisBT Group |