Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004808Openbravo ERPI. Performancepublic2008-09-03 18:272008-09-10 10:04
networkb 
iperdomo 
normalmajoralways
closedout of date 
20
2.35MP5 
 
Core
No
0004808: It takes too much time to show all the products when you have many products
When 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
A 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.
No tags attached.
blocks defect 0004798 closed iperdomo It takes too much time to show all the products when you have many products 
Issue History
2008-09-03 18:27cromeroNew Issue
2008-09-03 18:27cromeroAssigned To => iperdomo
2008-09-03 18:27cromeroStatusnew => scheduled
2008-09-10 10:04cromeroRegression testing => No
2008-09-10 10:04cromeroStatusscheduled => closed
2008-09-10 10:04cromeroNote Added: 0008968
2008-09-10 10:04cromeroResolutionopen => out of date

Notes
(0008968)
cromero   
2008-09-10 10:04   
This bug only applies to 2.3x version.