Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009642
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajorhave not tried2009-06-25 16:362009-07-10 12:39
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.40MP7
StatusclosedFix in branch2.40Fixed in SCM revision25a318a7b0f7
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009642: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0009641 closedshuehner Navigating to first record in generated windows is too slow with many records. 

-  Notes
(0017589)
hgbot (developer)
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 (developer)
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 (administrator)
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 (reporter)
2009-07-10 12:39

 Tested working fine

- Issue History
Date Modified Username Field Change
2009-06-25 16:36 shuehner Type defect => backport
2009-06-25 16:36 shuehner fix_in_branch => 2.40
2009-06-25 16:40 hgbot Checkin
2009-06-25 16:40 hgbot Note Added: 0017589
2009-06-25 16:40 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/80112d89ba6dcd586fec72a7f6168a0b3b1811d1 [^]
2009-06-25 16:59 hgbot Checkin
2009-06-25 16:59 hgbot Note Added: 0017591
2009-06-25 16:59 hgbot Status scheduled => resolved
2009-06-25 16:59 hgbot Resolution open => fixed
2009-06-25 16:59 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/80112d89ba6dcd586fec72a7f6168a0b3b1811d1 [^] => http://code.openbravo.com/erp/stable/2.40/rev/25a318a7b0f7889d1ff817c0d67b5089503649c7 [^]
2009-06-25 17:11 shuehner Note Added: 0017592
2009-07-10 12:39 sureshbabu Status resolved => closed
2009-07-10 12:39 sureshbabu Note Added: 0018095
2009-07-10 12:39 sureshbabu Fixed in Version => 2.40MP7

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker