Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009854Openbravo ERPA. Platformpublic2009-07-13 15:202009-07-23 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave 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
Summary0009854: 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
Tags250MP3releasecandidate, leo
Relationships
depends on backport 0009855 closed shuehner ProductMultiple selector is slow with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-13 15:20shuehnerNew Issue
2009-07-13 15:20shuehnerAssigned To => shuehner
2009-07-13 15:21shuehnerStatusnew => scheduled
2009-07-13 15:21shuehnerfix_in_branch => pi
2009-07-13 15:26hgbotCheckin
2009-07-13 15:26hgbotNote Added: 0018165
2009-07-13 15:26hgbotStatusscheduled => resolved
2009-07-13 15:26hgbotResolutionopen => fixed
2009-07-13 15:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/69fee1799264e5053b2361d6579c809c0f00c3f9 [^]
2009-07-13 15:28shuehnerNote Added: 0018166
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:17elopioStatusresolved => closed
2009-07-23 00:00anonymoussf_bug_id0 => 2825607

Notes
(0018165)
hgbot   
2009-07-13 15:26   
Repository: erp/devel/pi
Changeset: 69fee1799264e5053b2361d6579c809c0f00c3f9
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jul 13 15:25:53 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/69fee1799264e5053b2361d6579c809c0f00c3f9 [^]

Fixed 9854: Optimize performanec of ProductMultiple selector with many products:
- cleanup: remove unsused private 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
---
(0018166)
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)
- returning of rows to the calling pages when start+end of selected record are minimum 3 pages (in the selector) apart) (only 2.50)