Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019673Openbravo ERPI. Performancepublic2012-02-07 09:182012-03-02 15:35
Reporteregoitz 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP7.1 
Target Version3.0MP9Fixed in Version3.0MP9 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019673: Bad Performance on product selector having 50000 products and two pricelisteversion
DescriptionBad Performance on product selector having 50000 products and two pricelisteversion

Steps To ReproduceAdd 50000 productos on the product table and two pricelistversion having on each version the prices for all the products.
Then use the product selector on purchase order line..
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-02-07 09:18egoitzNew Issue
2012-02-07 09:18egoitzAssigned To => egoitz
2012-02-07 09:18egoitzModules => Core
2012-02-07 09:51hgbotCheckin
2012-02-07 09:51hgbotNote Added: 0044901
2012-02-07 09:51hgbotStatusnew => resolved
2012-02-07 09:51hgbotResolutionopen => fixed
2012-02-07 09:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b3dd8df9ad41d4041fafd94df1d472368b8cc7c4 [^]
2012-03-02 12:57jonalegriaesarteNote Added: 0045701
2012-03-02 12:57jonalegriaesarteStatusresolved => closed
2012-03-02 12:57jonalegriaesarteFixed in Version => 3.0MP9
2012-03-02 15:35hudsonbotCheckin
2012-03-02 15:35hudsonbotNote Added: 0045765

Notes
(0044901)
hgbot   
2012-02-07 09:51   
Repository: erp/devel/pi
Changeset: b3dd8df9ad41d4041fafd94df1d472368b8cc7c4
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Tue Feb 07 09:50:01 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b3dd8df9ad41d4041fafd94df1d472368b8cc7c4 [^]

Fixed Issue 19673. Peformance on product selector

---
M src-db/database/model/tables/M_PRODUCTPRICE.xml
---
(0045701)
jonalegriaesarte   
2012-03-02 12:57   
Verfied
(0045765)
hudsonbot   
2012-03-02 15:35   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test