0005204: 'Product Complete' Selector does take a very long time to open with many products

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	OBNetwork customer	=> No
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

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