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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0021639

3.0MP16

closed

dmiguelez

Product selector in purchase order takes a long time to load the data

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2012-09-13 17:39	egoitz	New Issue
2012-09-13 17:39	egoitz	Assigned To	=> AugustoMauch
2012-09-13 17:39	egoitz	Modules	=> Core
2012-09-13 18:26	AugustoMauch	Closed by	=> AugustoMauch
2012-09-13 18:26	AugustoMauch	Relationship added	duplicate of 0021639
2012-09-13 18:26	AugustoMauch	Status	new => closed
2012-09-13 18:26	AugustoMauch	Resolution	open => duplicate