Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027740Openbravo ERP07. Sales managementpublic2014-10-02 12:412015-02-24 17:04
Reporteregoitz 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket31399
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027740: poor performance when completing a shipment with many lines
Descriptionpoor performance when completing a shipment with many lines.
It happens when there are thousands of rows on the m_reservation_stock table and when there are thousands of lines per product with different attributesetintance.




Steps To ReproduceExecute the m_inout_post on an enviroment with thousends of row on m_reservation_stock table and thousands of lines per product with different attributesetintance.
Proposed Solutionchange the m_transaction_trg2 trigger by adding a condition as following
if NEW.m_attributesetinstance_id is null or NEW.m_attributesetinstance_id = '0' then

to do different queries depending on the attribute.
When the attributesetinstance_id is null or 0 use the coalesce on the whereclause
if not remove it.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0027713 closed eduardo_Argal slow post of goods shipment if there are many storage detail for that product 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-10-02 12:41egoitzNew Issue
2014-10-02 12:41egoitzAssigned To => dmiguelez
2014-10-02 12:41egoitzOBNetwork customer => Yes
2014-10-02 12:41egoitzModules => Core
2014-10-02 12:41egoitzSupport ticket => 31399
2014-10-02 12:41egoitzResolution time => 1413324000
2014-10-02 12:41egoitzTriggers an Emergency Pack => No
2014-10-02 12:45egoitzRelationship addedrelated to 0027713
2014-10-08 09:40jpcalventeIssue Monitored: jpcalvente
2014-10-13 12:24eduardo_ArgalAssigned Todmiguelez => eduardo_Argal
2014-10-13 12:25eduardo_ArgalStatusnew => scheduled
2014-10-13 12:25eduardo_Argalfix_in_branch => pi
2015-02-24 17:04SandrahuguetNote Added: 0074861
2015-02-24 17:04SandrahuguetReview Assigned To => Sandrahuguet
2015-02-24 17:04SandrahuguetStatusscheduled => closed
2015-02-24 17:04SandrahuguetResolutionopen => fixed

Notes
(0074861)
Sandrahuguet   
2015-02-24 17:04   
Fixed in issue 27160, C_Order_Post poor performance

https://code.openbravo.com/erp/devel/pi/rev/7091c40b9be09114b26b6cefeb45bc30c2650bf3 [^]