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-10-06 08:10
Reporterswathi_kamalView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityurgentResolutionno 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

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 Filesdiff file icon 50302.diff [^] (2,915 bytes) 2022-10-06 08:10 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
marvintm (manager)
2022-10-06 08:08

Adding those indices for all customers doesn't seem to be a good decision, as it will make insertion slow for all of them ,and especially the orderline and invoiceline tables are generally already quite big, but at the same time it will not necessarily provide a huge benefit for them.

If some customer in particular needs those indices, they can be added for them specifically.

- 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
2022-09-27 08:41 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2022-09-27 08:41 ranjith_qualiantech_com Status new => scheduled
2022-10-06 08:08 marvintm Note Added: 0141710
2022-10-06 08:08 marvintm Status scheduled => closed
2022-10-06 08:08 marvintm Resolution open => no change required
2022-10-06 08:08 marvintm Review Assigned To => marvintm
2022-10-06 08:10 ranjith_qualiantech_com File Added: 50302.diff

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker