Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005259Openbravo ERP07. Sales managementpublic2008-09-25 11:552009-05-21 16:37
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005259: 'Invoice line 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 invoice lines exist in the database.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum, Sprint-1
Relationships
blocks defect 0005258 closed shuehner 'Invoice line Complete' Selector does take a very long time to open with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-25 11:55shuehnerNew Issue
2008-09-25 11:55shuehnerAssigned To => shuehner
2008-09-25 11:55shuehnerStatusnew => scheduled
2008-09-25 12:16svnbotCheckin
2008-09-25 12:16svnbotNote Added: 0009191
2008-09-25 12:16svnbotStatusscheduled => resolved
2008-09-25 12:16svnbotResolutionopen => fixed
2008-09-25 12:16svnbotsvn_revision => 7887
2008-09-25 12:16shuehnerTag Attached: performance2.40scrum
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-24 18:16iperdomoTag Detached: sprint1
2008-10-24 18:16iperdomoTag Attached: Sprint-1
2009-05-21 16:37psarobeStatusresolved => closed

Notes
(0009191)
svnbot   
2008-09-25 12:16   
Repository: openbravo
Revision: 7887
Author: huehner
Date: 2008-09-25 12:16:07 +0200 (Thu, 25 Sep 2008)

Fixed 5259
Improve performance of the invoice line selector:
- use faster query for counting rows in filter
- optimize query for getting the data
- fix bug with limiting the data
- optimize out single widlcards in textfields

---
U branches/r2.40performance/src/org/openbravo/erpCommon/info/InvoiceLine.java
U branches/r2.40performance/src/org/openbravo/erpCommon/info/InvoiceLine_data.xsql
---

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