Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005242Openbravo ERP07. Sales managementpublic2008-09-24 17:482009-04-21 11:05
shuehner 
shuehner 
normalminorN/A
closedfixed 
5
pi 
 
Core
No
0005242: 'Invoice' Selector does take a very long time to open with many invoices
This selector takes a long time to open or update when a lot of invoices exist in the database.
performance2.40scrum, Sprint-1
depends on backport 0005243 closed shuehner 'Invoice' Selector does take a very long time to open with many invoices 
Issue History
2008-09-24 17:48shuehnerNew Issue
2008-09-24 17:48shuehnerAssigned To => shuehner
2008-09-24 17:48shuehnersf_bug_id0 => 2126679
2008-09-24 17:48shuehnerRegression testing => No
2008-09-24 17:49shuehnerSummary'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:50shuehnerStatusnew => scheduled
2008-09-24 17:50shuehnerfix_in_branch => trunk
2008-09-24 18:05svnbotCheckin
2008-09-24 18:05svnbotNote Added: 0009178
2008-09-24 18:05svnbotStatusscheduled => resolved
2008-09-24 18:05svnbotResolutionopen => fixed
2008-09-24 18:05svnbotsvn_revision => 7859
2008-09-24 18:05shuehnerTag Attached: performance2.40scrum
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-24 18:17iperdomoTag Detached: sprint1
2008-10-24 18:17iperdomoTag Attached: Sprint-1
2009-04-21 11:05psarobeStatusresolved => closed

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