|View Issue Details[ Jump to Notes ]||[ Issue History ] [ Print ]|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|defect||[Retail Modules] Web POS||major||always||2022-09-21 15:00||2022-10-06 08:10|
|Priority||urgent||Resolution||no change required||Fixed in Version|
|Status||closed||Fix in branch||Fixed in SCM revision|
|OS Version||Database version||Ant version|
|Product Version||SCM revision|
|Review Assigned To||marvintm|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
0050302: Adding Index on the Orderline and Invoiceline table to improve the performance.
|Description||Delete 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|
Fix: Create indexes on the m_offer_id column on the 4 tables.
|Tags||No tags attached.|
|Attached Files||50302.diff [^] (2,915 bytes) 2022-10-06 08:10 [Show Content]|
|Relationships [ Relation Graph ] [ Dependency Graph ]|
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.
|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|