Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007898Openbravo ERP00. Application dictionarypublic2009-03-02 15:502009-04-22 00:01
Reporternetworkb 
Assigned Toshuehner 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40beta 
Target VersionFixed in Version2.50 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007898: Product selector takes several time to show about 4000 products
DescriptionIn Sales order lines, when product selector is open, it takes several to show all products (about more than 4000 products are stored in database).

Steps To Reproduce(Note: several products must be stored in the database)

Go to Sales order > Lines.
Open Product selector.
It takes several time to show all products in the grid
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0005126 closed shuehner Product Selector does take a very long time to open with many products 
depends on backport 0007900 closed shuehner Product selector takes several time to show about 4000 products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-02 15:50networkbNew Issue
2009-03-02 15:50networkbAssigned To => rafaroda
2009-03-02 15:50networkbOBNetwork customer => Yes
2009-03-02 15:50networkbRegression testing => No
2009-03-02 15:54rafarodaNote Added: 0014228
2009-03-02 15:54rafarodaAssigned Torafaroda => shuehner
2009-03-02 16:02shuehnerNote Added: 0014229
2009-03-02 16:42shuehnerRelationship addedrelated to 0005126
2009-03-02 17:00shuehnerStatusnew => scheduled
2009-03-02 17:00shuehnerfix_in_branch => trunk
2009-03-02 17:19hgbotCheckin
2009-03-02 17:19hgbotNote Added: 0014234
2009-03-02 17:19hgbotStatusscheduled => resolved
2009-03-02 17:19hgbotResolutionopen => fixed
2009-03-02 17:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/27857f98b2e35f9ea5fd0dd34cb9f3ca5f1591ca [^]
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:01anonymoussf_bug_id0 => 2778037

Notes
(0014228)
rafaroda   
2009-03-02 15:54   
Since this is reported against 2.40 beta, determine whether this issue has been solved with performance enhancements.
(0014229)
shuehner   
2009-03-02 16:02   
The present enhancements improve the situation but do not solve it completely. I have a patch prepared to solve the remaining problem.
(0014234)
hgbot   
2009-03-02 17:19   
Repository: erp/devel/pi
Changeset: 27857f98b2e35f9ea5fd0dd34cb9f3ca5f1591ca
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Mar 02 17:17:25 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/27857f98b2e35f9ea5fd0dd34cb9f3ca5f1591ca [^]

Fixed 7898: fixed slow Product selector performance when using BOM

---
M src-db/database/model/tables/M_PRODUCT_BOM.xml
---