Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005338Openbravo ERPA. Platformpublic2008-09-30 12:432009-04-21 11:06
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0005338: Using the First/Previous/Next/Last record buttons in generated windows is slow with lots of data in the table
DescriptionUsing the navigation button for i.e. the Sales Order window is slow when there are lots of sales orders in the system.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum
Relationships
depends on backport 0005339 closed shuehner Using the First/Previous/Next/Last record buttons in generated windows is slow with lots of data in the table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-30 12:43shuehnerNew Issue
2008-09-30 12:43shuehnerAssigned To => cromero
2008-09-30 12:43shuehnersf_bug_id0 => 2137982
2008-09-30 12:43shuehnerRegression testing => No
2008-09-30 12:43shuehnerAssigned Tocromero => shuehner
2008-09-30 12:43shuehnerTag Attached: performance2.40scrum
2008-09-30 12:43shuehnerStatusnew => scheduled
2008-09-30 12:43shuehnerfix_in_branch => trunk
2008-09-30 18:59svnbotCheckin
2008-09-30 18:59svnbotNote Added: 0009296
2008-09-30 18:59svnbotsvn_revision => 8110
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-24 17:35iperdomoTag Detached: sprint1
2008-11-26 19:49svnbotCheckin
2008-11-26 19:49svnbotNote Added: 0010747
2008-11-26 19:49svnbotStatusscheduled => resolved
2008-11-26 19:49svnbotResolutionopen => fixed
2008-11-26 19:49svnbotsvn_revision8110 => 10650
2009-04-21 11:06psarobeStatusresolved => closed

Notes
(0009296)
svnbot   
2008-09-30 18:59   
Repository: openbravo
Revision: 8110
Author: huehner
Date: 2008-09-30 18:59:20 +0200 (Tue, 30 Sep 2008)

Issue 5338
Improve response time and decrease memory consumption for
the navigation buttons in WAD-generated windows by not
assembling a list of all id's, but parsing the id's on the fly.

---
U trunk/src/org/openbravo/erpCommon/utility/ExecuteQuery.java
U trunk/src-wad/src/org/openbravo/wad/javasource.javaxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=8110&sc=1 [^]
(0010747)
svnbot   
2008-11-26 19:49   
Repository: openbravo
Revision: 10650
Author: huehner
Date: 2008-11-26 19:49:27 +0100 (Wed, 26 Nov 2008)

Fixed 5338
Second part of this issue:
- use sysdate instead of now for transactional windows on oracle
- use better sql for in the first/last/previous/next -record and getKeyPosition methods

---
U trunk/src/org/openbravo/erpCommon/utility/DataGrid.java
U trunk/src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
U trunk/src/org/openbravo/erpCommon/utility/TableSQLData.java
U trunk/src-wad/src/org/openbravo/wad/javasource.javaxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10650&sc=1 [^]