Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009855Openbravo ERPA. Platformpublic2009-07-13 15:202009-07-22 13:34
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.40MP8 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009855: ProductMultiple selector is slow with many products
DescriptionThis selector takes about 5s to open and show the lines when used with about 100k products.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009854 closed shuehner ProductMultiple selector is slow with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-13 15:21shuehnerTypedefect => backport
2009-07-13 15:21shuehnerfix_in_branch => 2.40
2009-07-13 15:28shuehnerNote Added: 0018167
2009-07-17 15:23hgbotCheckin
2009-07-17 15:23hgbotNote Added: 0018372
2009-07-17 15:23hgbotStatusscheduled => resolved
2009-07-17 15:23hgbotResolutionopen => fixed
2009-07-17 15:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/c7b3174134c9e28035cb6c27eaf7c3c56d4691e8 [^]
2009-07-22 13:34sureshbabuStatusresolved => closed
2009-07-22 13:34sureshbabuNote Added: 0018557
2009-07-22 13:34sureshbabuFixed in Version => 2.40MP8

Notes
(0018167)
shuehner   
2009-07-13 15:28   
Testing needed (regressions in normal functionality of the selector):

- Filtering by all of the possible filter fields
- different Ordering
- returning of one or multiple rows to the calling page (check if first and last selected row is correctly included)
(0018372)
hgbot   
2009-07-17 15:23   
Repository: erp/stable/2.40
Changeset: c7b3174134c9e28035cb6c27eaf7c3c56d4691e8
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jul 13 15:22:55 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/c7b3174134c9e28035cb6c27eaf7c3c56d4691e8 [^]

Fixed 9855: Improve ProductMultiple selector performance with many products
- cleanup: remove unsused printPageFrame1 method
- use seperate count query to count number of rows
- optimize placement of limit/offset for postgres
- optimize placement of rownum for oracle

---
M src/org/openbravo/erpCommon/info/ProductMultiple.java
M src/org/openbravo/erpCommon/info/ProductMultiple_data.xsql
---
(0018557)
sureshbabu   
2009-07-22 13:34   
Tested working as per the comments given by the developer