Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005607Openbravo ERP09. Financial managementpublic2008-10-21 16:262009-04-21 11:05
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
Summary0005607: Debt/Payment selector takes a long time to search, if there are lots of payments
DescriptionThis selector is very slow/does not show data at all (timeout) when there are a lot of payments.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum, Sprint-2
Relationships
depends on backport 0005608 closed shuehner Debt/Payment selector takes a long time to search, if there are lots of payments 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-21 16:26shuehnerNew Issue
2008-10-21 16:26shuehnerAssigned To => shuehner
2008-10-21 16:26shuehnersf_bug_id0 => 2184573
2008-10-21 16:26shuehnerRegression testing => No
2008-10-21 16:27shuehnerStatusnew => scheduled
2008-10-21 16:27shuehnerfix_in_branch => trunk
2008-10-21 16:27shuehnerTag Attached: performance2.40scrum
2008-10-21 16:30svnbotCheckin
2008-10-21 16:30svnbotNote Added: 0009667
2008-10-21 16:30svnbotStatusscheduled => resolved
2008-10-21 16:30svnbotResolutionopen => fixed
2008-10-21 16:30svnbotsvn_revision => 8985
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-23 11:04iperdomoTag Detached: sprint1
2008-10-23 11:05iperdomoTag Attached: Sprint-2
2009-04-21 11:05psarobeStatusresolved => closed

Notes
(0009667)
svnbot   
2008-10-21 16:30   
Repository: openbravo
Revision: 8985
Author: huehner
Date: 2008-10-21 16:30:26 +0200 (Tue, 21 Oct 2008)

Fixed 5607
Optimize performance with many payments.
This change disables sorting for: Payment Rule, Canceled Settlement and
Generated Settlement which is a feature regression.

---
U trunk/src/org/openbravo/erpCommon/info/DebtPayment.java
U trunk/src/org/openbravo/erpCommon/info/DebtPayment_data.xsql
---

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