Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018107Openbravo ERPI. Performancepublic2011-07-28 08:152011-09-07 17:10
Reportermalsasua 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version3.0MP1 
Target Version3.0MP4Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018107: several minutes the CPU to 100 % when the table "product_price" has got a big number of records
Descriptionif you have got a big number of records in the table "product_price", if you edit in "form mode" a line of sales order window, the CPU is loaded to 100 % during several minutes
Steps To Reproduce. create 1500 products
. create 500 records in pricelist and pricelist_version tables
. create 1.000.000 records in product_price table
. create a new sales order.
. create a new line: when you enter to the line, to edit in "form mode", the CPU is loaded to 100%

the problem is generated by the next query:
select productbyp0_.M_Product_Price_Warehouse_V_ID as M1_447_, productbyp0_.AD_Client_ID as AD2_447_, productbyp0_.AD_Org_ID as AD3_447_, productbyp0_.Isactive as Isactive447_, productbyp0_.Updated as Updated447_, productbyp0_.Updatedby as Updatedby447_, productbyp0_.Created as Created447_, productbyp0_.Createdby as Createdby447_, productbyp0_.M_Product_ID as M9_447_, productbyp0_.M_Warehouse_ID as M10_447_, productbyp0_.M_Productprice_ID as M11_447_, productbyp0_.QTY_Available as QTY12_447_, productbyp0_.QTY_Onhand as QTY13_447_, productbyp0_.QTY_Reserved as QTY14_447_, productbyp0_.QTY_Ordered as QTY15_447_, productbyp0_.Pricelist as Pricelist447_, productbyp0_.Pricestd as Pricestd447_, productbyp0_.Pricelimit as Pricelimit447_
from M_Product_Price_Warehouse_v productbyp0_ where (productbyp0_.AD_Org_ID in ('0' , 'B2B18708B6924502B9ABE5B72ADECFE6' , 'C025B6163F3A4B6A94E031CCCA3C7A6B'))
and (productbyp0_.AD_Client_ID in ('0947E36909B941AAAB131AE9A7D19701' , '0')) and productbyp0_.Isactive='Y'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00183133.0MP4 closed marvintm Bad performance of the partner selector having arround 100.000 partners 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-28 08:15malsasuaNew Issue
2011-07-28 08:15malsasuaAssigned To => gorkaion
2011-07-28 08:15malsasuaWeb browser => Google Chrome
2011-07-28 08:15malsasuaModules => Core
2011-07-28 08:15malsasuaOBNetwork customer => Yes
2011-07-28 08:15malsasuaResolution time => 1316383200
2011-07-28 13:06gorkaionAssigned Togorkaion => alostale
2011-08-05 12:56alostaleStatusnew => scheduled
2011-08-29 11:17alostaleNote Added: 0040532
2011-08-29 11:17alostaleStatusscheduled => feedback
2011-08-29 13:06alostaleRelationship addedrelated to 0018313
2011-08-31 11:34jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2011-08-31 11:34jonalegriaesarteNote Added: 0040603
2011-08-31 11:34jonalegriaesarteTarget Version3.0MP3 => 3.0MP4
2011-09-02 14:53malsasuaNote Added: 0040726
2011-09-07 17:09malsasuaStatusfeedback => scheduled
2011-09-07 17:09malsasuafix_in_branch => pi
2011-09-07 17:10malsasuaStatusscheduled => resolved
2011-09-07 17:10malsasuaFixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/0c139e47fb2149f2f614c93a5304cf04e21d7a1b [^]
2011-09-07 17:10malsasuaResolutionopen => fixed
2011-09-07 17:10malsasuaNote Added: 0040808
2011-09-07 17:10malsasuaStatusresolved => closed

Notes
(0040532)
alostale   
2011-08-29 11:17   
Is this issue still present after this changset?

https://code.openbravo.com/erp/devel/pi/rev/0c139e47fb2149f2f614c93a5304cf04e21d7a1b [^]
(0040603)
jonalegriaesarte   
2011-08-31 11:34   
Due to the load with other issues we were not able to research this one for MP3, are planning MP4 for it now.
(0040726)
malsasua   
2011-09-02 14:53   
the fix works for me
(0040808)
malsasua   
2011-09-07 17:10   
verified