Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005204
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminorN/A2008-09-23 14:472009-04-21 11:05
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision9182
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005204: '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.
Tagsperformance2.40scrum, Sprint-1, Sprint-2
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0005205 closedshuehner 'Product Complete' Selector does take a very long time to open with many products 

-  Notes
(0009155)
svnbot (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-09-23 14:47 shuehner New Issue
2008-09-23 14:47 shuehner Assigned To => cromero
2008-09-23 14:47 shuehner sf_bug_id 0 => 2124502
2008-09-23 14:47 shuehner Regression testing => No
2008-09-23 14:47 shuehner Assigned To cromero => shuehner
2008-09-23 14:47 shuehner Status new => scheduled
2008-09-23 14:47 shuehner fix_in_branch => trunk
2008-09-23 15:08 svnbot Checkin
2008-09-23 15:08 svnbot Note Added: 0009155
2008-09-23 15:08 svnbot svn_revision => 7735
2008-10-21 16:25 shuehner Tag Attached: performance2.40scrum
2008-10-23 07:48 iperdomo Tag Attached: sprint1
2008-10-24 15:22 shuehner Tag Detached: performance2.40scrum
2008-10-24 15:22 shuehner Tag Attached: performance2.40scrum
2008-10-24 15:22 shuehner Tag Attached: Sprint-1
2008-10-24 15:22 shuehner Tag Attached: Sprint-2
2008-10-24 15:33 svnbot Checkin
2008-10-24 15:33 svnbot Note Added: 0009741
2008-10-24 15:33 svnbot Status scheduled => resolved
2008-10-24 15:33 svnbot Resolution open => fixed
2008-10-24 15:33 svnbot svn_revision 7735 => 9182
2008-10-24 17:34 iperdomo Tag Detached: sprint1
2009-04-21 11:05 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker