Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005205Openbravo ERP02. Master data managementpublic2008-09-23 14:472009-05-21 16:37
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityN/A
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
Summary0005205: 'Product Complete' Selector does take a very long time to open with many products
DescriptionThis selector takes a long time to open or update when a lot of products exist in the database.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum, Sprint-1, Sprint-2
Relationships
blocks defect 0005204 closed shuehner 'Product Complete' Selector does take a very long time to open with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-23 14:47shuehnerNew Issue
2008-09-23 14:47shuehnerAssigned To => shuehner
2008-09-23 14:47shuehnerStatusnew => scheduled
2008-09-23 15:06svnbotCheckin
2008-09-23 15:06svnbotNote Added: 0009154
2008-09-23 15:06svnbotsvn_revision => 7734
2008-10-21 16:25shuehnerTag Attached: performance2.40scrum
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-24 15:22shuehnerTag Attached: Sprint-1
2008-10-24 15:22shuehnerTag Attached: Sprint-2
2008-10-24 15:26svnbotCheckin
2008-10-24 15:26svnbotNote Added: 0009739
2008-10-24 15:26svnbotStatusscheduled => resolved
2008-10-24 15:26svnbotResolutionopen => fixed
2008-10-24 15:26svnbotsvn_revision7734 => 9180
2008-10-24 15:28shuehnerNote Added: 0009740
2008-10-24 17:28iperdomoTag Detached: sprint1
2009-05-21 16:37psarobeStatusresolved => closed

Notes
(0009154)
svnbot   
2008-09-23 15:06   
Repository: openbravo
Revision: 7734
Author: huehner
Date: 2008-09-23 15:06:41 +0200 (Tue, 23 Sep 2008)

Issue 5205
Improve Performance of Product Complete selector, with stock=no:
- use faster query to count products in current filter
- optimize query for getting the data

---
U branches/r2.40performance/src/org/openbravo/erpCommon/info/ProductComplete.java
U branches/r2.40performance/src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=7734&sc=1 [^]
(0009739)
svnbot   
2008-10-24 15:26   
Repository: openbravo
Revision: 9180
Author: huehner
Date: 2008-10-24 15:26:11 +0200 (Fri, 24 Oct 2008)

Fixed 5205
Improve performance of the product complete selector (option with stock = y)

---
U branches/r2.40performance/src/org/openbravo/erpCommon/info/ProductComplete.java
U branches/r2.40performance/src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=9180&sc=1 [^]
(0009740)
shuehner   
2008-10-24 15:28   
The change to the selector with (with_stock= y) disables sorting by the following columns: Warehouse, Unit, Order No., Quant. Served, Quant. of order delivered
which is a feature regression.