Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005204Openbravo ERP02. Master data managementpublic2008-09-23 14:472009-04-21 11:05
shuehner 
shuehner 
normalminorN/A
closedfixed 
5
pi 
 
Core
No
0005204: 'Product Complete' Selector does take a very long time to open with many products
This selector takes a long time to open or update when a lot of products exist in the database.
performance2.40scrum, Sprint-1, Sprint-2
depends on backport 0005205 closed shuehner 'Product Complete' Selector does take a very long time to open with many products 
Issue History
2008-09-23 14:47shuehnerNew Issue
2008-09-23 14:47shuehnerAssigned To => cromero
2008-09-23 14:47shuehnersf_bug_id0 => 2124502
2008-09-23 14:47shuehnerRegression testing => No
2008-09-23 14:47shuehnerAssigned Tocromero => shuehner
2008-09-23 14:47shuehnerStatusnew => scheduled
2008-09-23 14:47shuehnerfix_in_branch => trunk
2008-09-23 15:08svnbotCheckin
2008-09-23 15:08svnbotNote Added: 0009155
2008-09-23 15:08svnbotsvn_revision => 7735
2008-10-21 16:25shuehnerTag Attached: performance2.40scrum
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-24 15:22shuehnerTag Detached: performance2.40scrum
2008-10-24 15:22shuehnerTag Attached: performance2.40scrum
2008-10-24 15:22shuehnerTag Attached: Sprint-1
2008-10-24 15:22shuehnerTag Attached: Sprint-2
2008-10-24 15:33svnbotCheckin
2008-10-24 15:33svnbotNote Added: 0009741
2008-10-24 15:33svnbotStatusscheduled => resolved
2008-10-24 15:33svnbotResolutionopen => fixed
2008-10-24 15:33svnbotsvn_revision7735 => 9182
2008-10-24 17:34iperdomoTag Detached: sprint1
2009-04-21 11:05psarobeStatusresolved => closed

Notes
(0009155)
svnbot   
2008-09-23 15:08   
Repository: openbravo
Revision: 7735
Author: huehner
Date: 2008-09-23 15:08:12 +0200 (Tue, 23 Sep 2008)

Issue 5204
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 trunk/src/org/openbravo/erpCommon/info/ProductComplete.java
U trunk/src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=7735&sc=1 [^]
(0009741)
svnbot   
2008-10-24 15:33   
Repository: openbravo
Revision: 9182
Author: huehner
Date: 2008-10-24 15:33:54 +0200 (Fri, 24 Oct 2008)

Fixed 5204
Improve performance of the product complete selector (option with stock = y)
This change disables sorting by the following columns: Warehouse, Unit, Order No., Quant. Served, Quant. of order delivered
which is a feature regression.

---
U trunk/src/org/openbravo/erpCommon/info/ProductComplete.java
U trunk/src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
---

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