Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004799Openbravo ERPI. Performancepublic2008-09-03 13:542008-10-08 22:42
Reporternetworkb 
Assigned Toiperdomo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP5 
Target VersionFixed in Version2.35MP9 
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
Summary0004799: It takes too much time to show all the products when you have many products
DescriptionWhen accessing to the Products catalog window in relation mode, it takes too much time (around 10 seconds) to show the results. Moreover, sometimes the results are not even shown and the user has to launch an additional product search in order to obtain some results. The window works fine in edition mode, but it has an unacceptable behavior when switching to relation mode.

In terms of volume, the complete customer's products catalog has 200.000 different products. We are having this problem with only 130.000 products and we are afraid that the problem will be worse with the complete catalog.

Hardware:
# 4 CPU(s): 4 x CPU model: Intel(R) Xeon(R) CPU E5405 @ 2.00GHz. Frequency:
1995.082
# Total memory: 4048 MB
# Memory free: 1397 MB
# Total swap: 1992 MB
# Swap free: 1992 MB
Steps To Reproduce
Proposed SolutionA possible is limiting the amount of products that are loaded in the relation mode (for example, 1.000) and only load the next block of products when navigating to the 1.001 or further products.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0004798 closed iperdomo It takes too much time to show all the products when you have many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-03 13:54cromeroNew Issue
2008-09-03 13:54cromeroAssigned To => iperdomo
2008-09-03 13:54cromeroStatusnew => scheduled
2008-09-11 12:48svnbotCheckin
2008-09-11 12:48svnbotNote Added: 0008998
2008-09-11 12:48svnbotStatusscheduled => resolved
2008-09-11 12:48svnbotResolutionopen => fixed
2008-09-11 12:48svnbotsvn_revision => 7195
2008-09-16 08:56svnbotCheckin
2008-09-16 08:56svnbotNote Added: 0009023
2008-09-16 08:56svnbotsvn_revision7195 => 7336
2008-10-08 22:42psarobeRegression testing => No
2008-10-08 22:42psarobeStatusresolved => closed
2008-10-08 22:42psarobeNote Added: 0009472

Notes
(0008998)
svnbot   
2008-09-11 12:48   
Repository: openbravo
Revision: 7195
Author: iperdomo
Date: 2008-09-11 12:48:47 +0200 (Thu, 11 Sep 2008)

Fixes issue 4799. Backported changes to improve performance on the grid.

---
U branches/r2.3x/src/org/openbravo/erpCommon/utility/DataGrid.java
U branches/r2.3x/src/org/openbravo/erpCommon/utility/ExecuteQuery.java
U branches/r2.3x/src/org/openbravo/erpCommon/utility/ExportGrid.java
U branches/r2.3x/src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
U branches/r2.3x/src/org/openbravo/erpCommon/utility/QueryFieldStructure.java
U branches/r2.3x/src/org/openbravo/erpCommon/utility/QueryParameterStructure.java
U branches/r2.3x/src/org/openbravo/erpCommon/utility/TableSQLData.java
U branches/r2.3x/src-wad/src/org/openbravo/wad/javasource.javaxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7195&sc=1 [^]
(0009023)
svnbot   
2008-09-16 08:56   
Repository: openbravo
Revision: 7336
Author: iperdomo
Date: 2008-09-16 08:56:23 +0200 (Tue, 16 Sep 2008)

Fixes export grid. Related to issue 4799

---
U branches/r2.3x/src/org/openbravo/erpCommon/utility/ExportGrid.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=7336&sc=1 [^]
(0009472)
psarobe   
2008-10-08 22:42   
Tested by consulting in a real environment