Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2012-09-13 17:392012-09-13 18:26
ReporteregoitzView Statuspublic 
Assigned ToAugustoMauch 
PriorityurgentResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version3.0MP16
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP14SCM revision 
Review Assigned ToAugustoMauch
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

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

DescriptionThe 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of defect 00216393.0MP16 closeddmiguelez 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker