Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023623Openbravo ERPA. Platformpublic2013-04-23 23:142018-04-04 17:26
Reporterjecharri 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023623: Performance problem in product selector
DescriptionPerformance problem in product selector

If you have 150000 products in your database, the product selector becomes useless when you want to find a product.
Steps To Reproduce-login in one environment with 150000 products
-Go to sales order
-create a header
-go to lines
-try to find a product

The system get collapsed during a minute or more and you can not work.
Proposed SolutionPlease review support ticket 20778 because the partner is telling that the problem is one left join that DAL creates
Additional Information
TagsMoved from MP26 to MP27, Performance
Relationships
related to defect 00238893.0MP24 closed AugustoMauch When searching on the field of a new selector the request to the datasource is done twice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-04-23 23:14jecharriNew Issue
2013-04-23 23:14jecharriAssigned To => AugustoMauch
2013-04-23 23:14jecharriWeb browser => Google Chrome
2013-04-23 23:14jecharriModules => Core
2013-04-23 23:14jecharriResolution time => 1369692000
2013-04-23 23:14jecharriTriggers an Emergency Pack => No
2013-04-23 23:15jecharriWeb browserGoogle Chrome => Google Chrome
2013-04-23 23:15jecharriProposed Solution updated
2013-04-23 23:17jecharriTag Attached: Performance
2013-05-07 16:05AugustoMauchWeb browserGoogle Chrome => Google Chrome
2013-05-07 16:05AugustoMauchTarget Version3.0MP23 => 3.0MP24
2013-05-22 06:31eintelauIssue Monitored: eintelau
2013-05-22 23:59egoitzRelationship addedrelated to 0023761
2013-05-23 00:00egoitzRelationship deletedrelated to 0023761
2013-05-23 00:00egoitzRelationship addedrelated to 0023889
2013-05-27 13:42jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-05-27 13:42jonalegriaesarteTarget Version3.0MP24 => 3.0MP25
2013-06-28 12:07AugustoMauchAssigned ToAugustoMauch => jecharri
2013-06-28 12:07AugustoMauchAssigned Tojecharri => dmiguelez
2013-06-28 12:08AugustoMauchNote Added: 0059772
2013-06-28 14:11jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-06-28 14:11jonalegriaesarteNote Added: 0059774
2013-06-28 14:11jonalegriaesarteTarget Version3.0MP25 => 3.0MP26
2013-07-29 16:36jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-07-29 16:36jonalegriaesarteTarget Version3.0MP26 => 3.0MP27
2013-07-29 16:36jonalegriaesarteTag Attached: Moved from MP26 to MP27
2013-08-19 16:41jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-08-19 16:41jonalegriaesarteTarget Version3.0MP27 => 3.0MP28
2013-09-23 16:26jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-09-23 16:26jonalegriaesarteNote Added: 0061353
2013-09-23 16:26jonalegriaesarteTypedefect => design defect
2013-09-23 16:30jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-09-23 16:30jonalegriaesarteTarget Version3.0MP28 =>
2014-02-16 12:59wimjassenNote Added: 0064282
2014-02-16 13:00wimjassenIssue Monitored: wimjassen
2018-04-04 17:26martinsdanIssue Monitored: martinsdan

Notes
(0059772)
AugustoMauch   
2013-06-28 12:08   
A new approach for this issue is to try to implement the product selector using a user defined datasource [1] and check if the performance is improved.

[1] http://wiki.openbravo.com/wiki/How_to_Create_a_Table_Based_on_a_User_Defined_Datasource [^]
(0059774)
jonalegriaesarte   
2013-06-28 14:11   
Needs to be analyzed first to implement a solution
(0061353)
jonalegriaesarte   
2013-09-23 16:26   
This selector needs to be redefined using a new technology based on datasources. In the meanwhile a ProductSimple reference has been created as a workaround when needed.
(0064282)
wimjassen   
2014-02-16 12:59   
The same problem occurs when you have less products (5000 or so) but you have multiple price lists. The selector is practically unusable because it takes up to a minute to load.