0021643: The product selector collapses the server when there are many rows on the m_productprice and m_storage_detail tables

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0021643

Openbravo ERP

A. Platform

public

2012-09-13 17:39

2012-09-13 18:26

Reporter

egoitz

Assigned To

AugustoMauch

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

3.0MP14

Target Version

3.0MP16

Fixed in Version

Merge Request Status

Review Assigned To

AugustoMauch

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0021643: The product selector collapses the server when there are many rows on the m_productprice and m_storage_detail tables

Description

The product selector collapses the server when there are many rows on the m_productprice and m_storage_detail tables.
For each key-press a request to the database is sent.
If each select takes long the cpu goes to 100% for a while and the combo takes too much to show the data.

If you made a mistake while writing the product to find and rewrite again propery the server collapses.

Steps To Reproduce

-On a a databawse with 316918 rows at m_productprice table and 42000 rows on the m_storage_detail table use the product selector.

-Use it writing the product to find
-open the top on the terminal to monitorize the system.
-See that for each key press a new postgresql process is executed.
-If the query takes arround 20 seconds to show data, it takes long to show the content of the combo

Proposed Solution

Additional Information