Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005152Openbravo ERP02. Master data managementpublic2008-09-22 12:552009-05-21 16:37
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0005152: Product Selector does take a very long time to open with many products
DescriptionThe SQL used in the product selector is not efficient when having 0029055:0075000 products.
=> the product selector does not work with this amount of work as it runs in a timeout
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum, Sprint-1
Relationships
depends on backport 0005180 closed shuehner DataGrid.js supports sortable=yes/no for each column, but not our DataGridStructure template for defining a grid 
blocks defect 0005126 closed shuehner Product Selector does take a very long time to open with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-22 12:55cromeroNew Issue
2008-09-22 12:55cromeroAssigned To => shuehner
2008-09-22 12:55cromeroStatusnew => scheduled
2008-09-23 10:28shuehnerRelationship addeddepends on 0005180
2008-09-23 10:54shuehnerTag Attached: performance2.40scrum
2008-09-23 11:06svnbotCheckin
2008-09-23 11:06svnbotNote Added: 0009148
2008-09-23 11:06svnbotStatusscheduled => resolved
2008-09-23 11:06svnbotResolutionopen => fixed
2008-09-23 11:06svnbotsvn_revision => 7693
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-24 18:15iperdomoTag Detached: sprint1
2008-10-24 18:15iperdomoTag Attached: Sprint-1
2008-10-30 19:11svnbotCheckin
2008-10-30 19:11svnbotNote Added: 0009857
2008-10-30 19:11svnbotsvn_revision7693 => 9465
2009-05-21 16:37psarobeStatusresolved => closed

Notes
(0009148)
svnbot   
2008-09-23 11:06   
Repository: openbravo
Revision: 7693
Author: huehner
Date: 2008-09-23 11:06:04 +0200 (Tue, 23 Sep 2008)

Fixed 5152
Improved performance of the product selector with many products:
- speed up counting of record in filter by using extra sql query
- rewrite data retrieving sql to first filter and limit and then calculate the rest of the data
- disable sorting of all columns besides: key,name (feature regression)

---
U branches/r2.40performance/src/org/openbravo/erpCommon/info/Product.java
U branches/r2.40performance/src/org/openbravo/erpCommon/info/Product_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=7693&sc=1 [^]
(0009857)
svnbot   
2008-10-30 19:11   
Repository: openbravo
Revision: 9465
Author: huehner
Date: 2008-10-30 19:11:37 +0100 (Thu, 30 Oct 2008)

Issue 5152
Fix error introduced in r7693 which did not show all relevant products in some cases.

---
U branches/r2.40performance/src/org/openbravo/erpCommon/info/Product.java
U branches/r2.40performance/src/org/openbravo/erpCommon/info/Product_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=9465&sc=1 [^]