Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009642Openbravo ERPA. Platformpublic2009-06-25 16:362009-07-10 12:39
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP7 
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
Summary0009642: Navigating to first record in generated windows is too slow with many records.
DescriptionExample: #products = 1.000.000
Opening the product window in edit mode. Then press ok in the automatically opened search popup. Retrieving the first product (which is shown after pressing OK) takes more than 1.5s for a single user.

This is too slow when you try to scale to many users.
Steps To ReproduceSee description.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009641 closed shuehner Navigating to first record in generated windows is too slow with many records. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-25 16:36shuehnerTypedefect => backport
2009-06-25 16:36shuehnerfix_in_branch => 2.40
2009-06-25 16:40hgbotCheckin
2009-06-25 16:40hgbotNote Added: 0017589
2009-06-25 16:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/80112d89ba6dcd586fec72a7f6168a0b3b1811d1 [^]
2009-06-25 16:59hgbotCheckin
2009-06-25 16:59hgbotNote Added: 0017591
2009-06-25 16:59hgbotStatusscheduled => resolved
2009-06-25 16:59hgbotResolutionopen => fixed
2009-06-25 16:59hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/80112d89ba6dcd586fec72a7f6168a0b3b1811d1 [^] => http://code.openbravo.com/erp/stable/2.40/rev/25a318a7b0f7889d1ff817c0d67b5089503649c7 [^]
2009-06-25 17:11shuehnerNote Added: 0017592
2009-07-10 12:39sureshbabuStatusresolved => closed
2009-07-10 12:39sureshbabuNote Added: 0018095
2009-07-10 12:39sureshbabuFixed in Version => 2.40MP7

Notes
(0017589)
hgbot   
2009-06-25 16:40   
Repository: erp/stable/2.40
Changeset: 80112d89ba6dcd586fec72a7f6168a0b3b1811d1
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 25 16:40:09 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/80112d89ba6dcd586fec72a7f6168a0b3b1811d1 [^]

Issue 9642: Reformat file in preperation of this issue.

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0017591)
hgbot   
2009-06-25 16:59   
Repository: erp/stable/2.40
Changeset: 25a318a7b0f7889d1ff817c0d67b5089503649c7
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 25 16:59:08 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/25a318a7b0f7889d1ff817c0d67b5089503649c7 [^]

Fixed 9642: Improve performance of generated window navigation
- Move rownum on oracle to better location
- Embedd limit/offset/rownum parameter values into sql-string instead of using preparedstatement parameters

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0017592)
shuehner   
2009-06-25 17:11   
@qa: this change affects all generated windows in edit & grid view.
- Navigation: first/previous/next/last
- grid edit->grid & grid->edit view
- scrolling in edit view (check for no duplicate rows, and no missing rows)
-- all three above with different sort order/filter/language (en_us + one more)
(0018095)
sureshbabu   
2009-07-10 12:39   
Tested working fine