0004999: It takes too much time to show all the products when you have many products

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004999

Openbravo ERP

I. Performance

public

2008-09-10 10:00

2008-09-10 10:04

Reporter

networkb

Assigned To

iperdomo

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

out of date

Platform

OS Version

Product Version

2.35MP5

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0004999: It takes too much time to show all the products when you have many products

Description

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

Steps To Reproduce

Proposed Solution

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.

Additional Information