0005242: 'Invoice' Selector does take a very long time to open with many invoices

Issue History
Date Modified	Username	Field	Change
2008-09-24 17:48	shuehner	New Issue
2008-09-24 17:48	shuehner	Assigned To	=> shuehner
2008-09-24 17:48	shuehner	sf_bug_id	0 => 2126679
2008-09-24 17:48	shuehner	Regression testing	=> No
2008-09-24 17:49	shuehner	Summary	'Sales Invoice' Selector does take a very long time to open with many invoices => 'Invoice' Selector does take a very long time to open with many invoices
2008-09-24 17:50	shuehner	Status	new => scheduled
2008-09-24 17:50	shuehner	fix_in_branch	=> trunk
2008-09-24 18:05	svnbot	Checkin
2008-09-24 18:05	svnbot	Note Added: 0009178
2008-09-24 18:05	svnbot	Status	scheduled => resolved
2008-09-24 18:05	svnbot	Resolution	open => fixed
2008-09-24 18:05	svnbot	svn_revision	=> 7859
2008-09-24 18:05	shuehner	Tag Attached: performance2.40scrum
2008-10-23 07:48	iperdomo	Tag Attached: sprint1
2008-10-24 18:17	iperdomo	Tag Detached: sprint1
2008-10-24 18:17	iperdomo	Tag Attached: Sprint-1
2009-04-21 11:05	psarobe	Status	resolved => closed

Notes
(0009178) svnbot (reporter) 2008-09-24 18:05	Repository: openbravo Revision: 7859 Author: huehner Date: 2008-09-24 18:05:43 +0200 (Wed, 24 Sep 2008) Fixed 5242 Improve Performance of the Invoice selector: - use faster query for counting invoices in current filter - improve query for getting the data - disable sorting for column converted (feature regression!) --- U trunk/src/org/openbravo/erpCommon/info/Invoice.java U trunk/src/org/openbravo/erpCommon/info/Invoice_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=7859&sc=1 [^]