Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010344Openbravo ERPI. Performancepublic2009-08-19 18:052009-09-24 00:00
Reporterklawandronic 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.40MP8 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010344: org.openbravo.erpCommon.utility.ComboTableData performance issue on PostgreSQL
DescriptionThis issue is related to http://issues.openbravo.com/view.php?id=10318 [^]
Steps To ReproduceSee the same link
Proposed SolutionI've attached the patch fixing this issue
Additional Information
TagsNo tags attached.
Relationships
related to defect 0010318 closed shuehner Big performance issue on PostgreSQL with large table data 
depends on backport 0010718 closed shuehner org.openbravo.erpCommon.utility.ComboTableData performance issue on PostgreSQL 
related to defect 0010715 closed shuehner On SQL error when using ComboTableData on postgres only error message is '0' instead of the real database error 
Attached Filespatch buffer.patch (2,668) 2009-08-19 18:05
https://issues.openbravo.com/file_download.php?file_id=1665&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-08-19 18:05klawandronicNew Issue
2009-08-19 18:05klawandronicAssigned To => rafaroda
2009-08-19 18:05klawandronicFile Added: buffer.patch
2009-08-19 18:05klawandronicIssue Monitored: klawandronic
2009-08-20 06:38rafarodaNote Added: 0019081
2009-08-20 06:38rafarodaAssigned Torafaroda => shuehner
2009-08-20 06:38rafarodaPrioritynormal => urgent
2009-08-20 06:38rafarodaStatusnew => acknowledged
2009-08-20 06:38rafarodaRelationship addedrelated to 0010318
2009-09-23 15:40shuehnerRelationship addedrelated to 0010715
2009-09-23 16:13shuehnerStatusacknowledged => scheduled
2009-09-23 16:13shuehnerfix_in_branch => pi
2009-09-23 16:14shuehnerStatusscheduled => closed
2009-09-23 16:14shuehnerNote Added: 0020318
2009-09-23 16:14shuehnerResolutionopen => no change required
2009-09-24 00:00anonymoussf_bug_id0 => 2865301

Notes
(0019081)
rafaroda   
2009-08-20 06:38   
Stefan,

Could you please have a look at this issue and patch?

Please discuss with Isma whether this has to be backported to 2.40 branch or not.

Thanks.
(0020318)
shuehner   
2009-09-23 16:14   
No change is required in pi as there no to_number for pk values is needed because of uuid's. Needed backport for 2.40 is tracked in issue 10718.