Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009834Openbravo ERPA. Platformpublic2009-07-10 19:272009-07-23 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP3 
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
Summary0009834: Product selector is too slow on postgres with many products
DescriptionThe Product selector is too slow when used with many products. Tested on postgres with 100k products.
Steps To Reproduce
Proposed Solution
Additional Information
Tags250MP3releasecandidate, leo
Relationships
depends on backport 0009835 closed shuehner Product selector is too slow on postgres with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-10 19:27shuehnerNew Issue
2009-07-10 19:27shuehnerAssigned To => shuehner
2009-07-10 19:28shuehnerStatusnew => scheduled
2009-07-10 19:28shuehnerfix_in_branch => pi
2009-07-10 19:34hgbotCheckin
2009-07-10 19:34hgbotNote Added: 0018119
2009-07-10 19:34hgbotStatusscheduled => resolved
2009-07-10 19:34hgbotResolutionopen => fixed
2009-07-10 19:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ddfccc031c6fda630c20415f3a29638bdcf08161 [^]
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-21 18:43psarobeTag Attached: leo
2009-07-22 06:10elopioStatusresolved => closed
2009-07-23 00:00anonymoussf_bug_id0 => 2825610

Notes
(0018119)
hgbot   
2009-07-10 19:34   
Repository: erp/devel/pi
Changeset: ddfccc031c6fda630c20415f3a29638bdcf08161
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Jul 10 19:33:48 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ddfccc031c6fda630c20415f3a29638bdcf08161 [^]

Fixed 9834: Optimize product selector performance on postgres
- removal of not needed joins in count query
- better placement of limit/offset so orderby + limit can be optimized by postgres

---
M src/org/openbravo/erpCommon/info/Product.java
M src/org/openbravo/erpCommon/info/Product_data.xsql
---