Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010718Openbravo ERPI. Performancepublic2009-08-19 18:052009-10-12 11:49
Reporterklawandronic 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP8 
Target VersionFixed in Version2.40MP10 
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
Summary0010718: 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 backport 00109892.40MP11 closed shuehner Time response of query generated by WAD is very high 
blocks defect 0010344 closed shuehner org.openbravo.erpCommon.utility.ComboTableData performance issue on PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-23 16:13shuehnerTypedefect => backport
2009-09-23 16:13shuehnerfix_in_branch => 2.40
2009-09-23 16:19hgbotCheckin
2009-09-23 16:19hgbotNote Added: 0020320
2009-09-23 16:19hgbotStatusscheduled => resolved
2009-09-23 16:19hgbotResolutionopen => fixed
2009-09-23 16:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/86ca816aed25abd180fb8fc3f5a037e6e800ee77 [^]
2009-09-29 12:02hgbotCheckin
2009-09-29 12:02hgbotNote Added: 0020445
2009-09-29 12:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/86ca816aed25abd180fb8fc3f5a037e6e800ee77 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/86ca816aed25abd180fb8fc3f5a037e6e800ee77 [^]
2009-10-12 11:49arunkumarStatusresolved => closed
2009-10-12 11:49arunkumarNote Added: 0020943
2009-10-12 11:49arunkumarFixed in Version => 2.40MP10
2009-10-16 15:27shuehnerRelationship addedrelated to 0010989

Notes
(0020320)
hgbot   
2009-09-23 16:19   
Repository: erp/stable/2.40
Changeset: 86ca816aed25abd180fb8fc3f5a037e6e800ee77
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Sep 23 16:17:46 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/86ca816aed25abd180fb8fc3f5a037e6e800ee77 [^]

Fixed 10718: Fix bad performance of ComboTableData on postgres
Based on patch prepared by Ville Lindfors. slightly modified by me

---
M src/org/openbravo/erpCommon/utility/ComboTableData.java
---
(0020445)
hgbot   
2009-09-29 12:02   
Repository: erp/stable/2.40_pageddatagrid
Changeset: 86ca816aed25abd180fb8fc3f5a037e6e800ee77
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Sep 23 16:17:46 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/86ca816aed25abd180fb8fc3f5a037e6e800ee77 [^]

Fixed 10718: Fix bad performance of ComboTableData on postgres
Based on patch prepared by Ville Lindfors. slightly modified by me

---
M src/org/openbravo/erpCommon/utility/ComboTableData.java
---
(0020943)
arunkumar   
2009-10-12 11:49   
Tested and the edit page is not taking much time to load even if the records are more.Working fine.