Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2022-09-21 15:002022-09-21 15:00
Reporterswathi_kamalView Statuspublic 
Assigned ToRetail 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0050302: Adding Index on the Orderline and Invoiceline table to improve the performance.

DescriptionDelete on the m_offer table causing IO and contention.
The delete was only for one offer but seems to be slow due to the foreign key in other tables referring to the m_offer_id column on the m_offer table.
When there is a constraint postgresql check if there is any row pointing to the deleted entry.
Steps To Reproduce The following tables pointing to the m_offer without index on the reference column
1. c_orderline
2. c_orderline_offer
3. c_invoiceline
4. c_invoiceline_offer

Fix: Create indexes on the m_offer_id column on the 4 tables.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2022-09-21 15:00 swathi_kamal New Issue
2022-09-21 15:00 swathi_kamal Assigned To => Retail
2022-09-21 15:00 swathi_kamal Triggers an Emergency Pack => No

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker