Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0047658
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2021-09-08 22:032021-09-20 06:50
ReportermalsasuaView Statuspublic 
Assigned ToRetail 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0047658: 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
TagsNo tags attached.
Attached Filesdiff file icon index.diff [^] (698 bytes) 2021-09-08 22:03 [Show Content]

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker