Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027740
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2014-10-02 12:412015-02-24 17:04
ReporteregoitzView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0027740: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0027713 closededuardo_Argal slow post of goods shipment if there are many storage detail for that product 

-  Notes
(0074861)
Sandrahuguet (viewer)
2015-02-24 17:04

 Fixed in issue 27160, C_Order_Post poor performance

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

- Issue History
Date Modified Username Field Change
2014-10-02 12:41 egoitz New Issue
2014-10-02 12:41 egoitz Assigned To => dmiguelez
2014-10-02 12:41 egoitz OBNetwork customer => Yes
2014-10-02 12:41 egoitz Modules => Core
2014-10-02 12:41 egoitz Support ticket => 31399
2014-10-02 12:41 egoitz Resolution time => 1413324000
2014-10-02 12:41 egoitz Triggers an Emergency Pack => No
2014-10-02 12:45 egoitz Relationship added related to 0027713
2014-10-08 09:40 jpcalvente Issue Monitored: jpcalvente
2014-10-13 12:24 eduardo_Argal Assigned To dmiguelez => eduardo_Argal
2014-10-13 12:25 eduardo_Argal Status new => scheduled
2014-10-13 12:25 eduardo_Argal fix_in_branch => pi
2015-02-24 17:04 Sandrahuguet Note Added: 0074861
2015-02-24 17:04 Sandrahuguet Review Assigned To => Sandrahuguet
2015-02-24 17:04 Sandrahuguet Status scheduled => closed
2015-02-24 17:04 Sandrahuguet Resolution open => fixed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker