Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004798Openbravo ERPI. Performancepublic2008-09-03 12:172009-04-21 11:07
Reporternetworkb 
Assigned Toiperdomo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP5 
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
Summary0004798: 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
TagsPerformance, performance2.40scrum
Relationships
depends on backport 0004799 closed iperdomo It takes too much time to show all the products when you have many products 
depends on backport 0004808 closed iperdomo It takes too much time to show all the products when you have many products 
depends on backport 0004999 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 12:17networkbNew Issue
2008-09-03 12:17networkbAssigned To => cromero
2008-09-03 12:17networkbsf_bug_id0 => 2090860
2008-09-03 12:17networkbRegression testing => No
2008-09-03 13:54cromeroStatusnew => scheduled
2008-09-03 13:54cromeroAssigned Tocromero => iperdomo
2008-09-03 13:54cromerofix_in_branch => trunk
2008-09-03 18:27cromeroStatusscheduled => feedback
2008-09-03 18:27cromeroStatusfeedback => scheduled
2008-09-10 10:00cromeroStatusscheduled => feedback
2008-09-10 10:00cromeroStatusfeedback => scheduled
2008-09-11 13:02svnbotCheckin
2008-09-11 13:02svnbotNote Added: 0008999
2008-09-11 13:02svnbotStatusscheduled => resolved
2008-09-11 13:02svnbotResolutionopen => fixed
2008-09-11 13:02svnbotsvn_revision => 7198
2008-12-16 12:55psarobeStatusresolved => new
2008-12-16 12:55psarobeResolutionfixed => open
2008-12-16 12:56psarobeTag Attached: Performance
2008-12-16 12:56psarobeTag Attached: performance2.40scrum
2008-12-16 12:57psarobeStatusnew => scheduled
2008-12-16 12:57psarobeStatusscheduled => resolved
2008-12-16 12:57psarobeResolutionopen => fixed
2009-04-21 11:07psarobeStatusresolved => closed

Notes
(0008999)
svnbot   
2008-09-11 13:02   
Repository: openbravo
Revision: 7198
Author: iperdomo
Date: 2008-09-11 13:02:41 +0200 (Thu, 11 Sep 2008)

Fixes issue 4798: The 60th record is show duplicated

---
U trunk/src/org/openbravo/erpCommon/utility/TableSQLData.java
---

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