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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004798
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajoralways2008-09-03 12:172009-04-21 11:07
ReporternetworkbView Statuspublic 
Assigned Toiperdomo 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7198
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.35MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004798: 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
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.
TagsPerformance, performance2.40scrum
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0004799 closediperdomo It takes too much time to show all the products when you have many products 
depends on backport 0004808 closediperdomo It takes too much time to show all the products when you have many products 
depends on backport 0004999 closediperdomo It takes too much time to show all the products when you have many products 

-  Notes
(0008999)
svnbot (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-09-03 12:17 networkb New Issue
2008-09-03 12:17 networkb Assigned To => cromero
2008-09-03 12:17 networkb sf_bug_id 0 => 2090860
2008-09-03 12:17 networkb Regression testing => No
2008-09-03 13:54 cromero Status new => scheduled
2008-09-03 13:54 cromero Assigned To cromero => iperdomo
2008-09-03 13:54 cromero fix_in_branch => trunk
2008-09-03 18:27 cromero Status scheduled => feedback
2008-09-03 18:27 cromero Status feedback => scheduled
2008-09-10 10:00 cromero Status scheduled => feedback
2008-09-10 10:00 cromero Status feedback => scheduled
2008-09-11 13:02 svnbot Checkin
2008-09-11 13:02 svnbot Note Added: 0008999
2008-09-11 13:02 svnbot Status scheduled => resolved
2008-09-11 13:02 svnbot Resolution open => fixed
2008-09-11 13:02 svnbot svn_revision => 7198
2008-12-16 12:55 psarobe Status resolved => new
2008-12-16 12:55 psarobe Resolution fixed => open
2008-12-16 12:56 psarobe Tag Attached: Performance
2008-12-16 12:56 psarobe Tag Attached: performance2.40scrum
2008-12-16 12:57 psarobe Status new => scheduled
2008-12-16 12:57 psarobe Status scheduled => resolved
2008-12-16 12:57 psarobe Resolution open => fixed
2009-04-21 11:07 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker