Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0050302Retail ModulesWeb POSpublic2022-09-21 15:002022-10-06 08:10
Reporterswathi_kamal 
Assigned Toranjith_qualiantech_com 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket48808
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0050302: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 50302.diff (2,915) 2022-10-06 08:10
https://issues.openbravo.com/file_download.php?file_id=17589&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-09-21 15:00swathi_kamalNew Issue
2022-09-21 15:00swathi_kamalAssigned To => Retail
2022-09-21 15:00swathi_kamalOBNetwork customer => Gold
2022-09-21 15:00swathi_kamalSupport ticket => 48808
2022-09-21 15:00swathi_kamalTriggers an Emergency Pack => No
2022-09-27 08:41ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2022-09-27 08:41ranjith_qualiantech_comStatusnew => scheduled
2022-10-06 08:08marvintmNote Added: 0141710
2022-10-06 08:08marvintmStatusscheduled => closed
2022-10-06 08:08marvintmResolutionopen => no change required
2022-10-06 08:08marvintmReview Assigned To => marvintm
2022-10-06 08:10ranjith_qualiantech_comFile Added: 50302.diff

Notes
(0141710)
marvintm   
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.