Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005624Openbravo ERP09. Financial managementpublic2008-10-23 11:252009-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
Summary0005624: BankStatement Header -> Creates Lines from is very slow with many payments
DescriptionThis Popup is very slow when there are many payments in the system.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum, Sprint-2
Relationships
blocks defect 0005623 closed shuehner BankStatement Header -> Creates Lines from is very slow with many payments 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-23 11:25shuehnerNew Issue
2008-10-23 11:25shuehnerAssigned To => shuehner
2008-10-23 11:25shuehnerStatusnew => scheduled
2008-10-23 11:45shuehnerStatusscheduled => resolved
2008-10-23 11:45shuehnersvn_revision => 9059
2008-10-23 11:45shuehnerResolutionopen => fixed
2008-10-23 11:45shuehnerNote Added: 0009698
2008-10-23 11:46shuehnerTag Attached: performance2.40scrum
2008-10-23 11:46shuehnerTag Attached: Sprint-2
2008-10-23 12:36svnbotCheckin
2008-10-23 12:36svnbotNote Added: 0009706
2008-10-23 12:36svnbotsvn_revision9059 => 9075
2009-05-21 16:37psarobeStatusresolved => closed

Notes
(0009698)
shuehner   
2008-10-23 11:45   
Fix 5624
Improve performance of the Bankstatement header -> Create Lines popup by:
- optimizing the queries
- changing behaviour:
The window will now only show a limited number of rows (set by a session preference)
and display a message if the current filter selects more rows.
(0009706)
svnbot   
2008-10-23 12:36   
Repository: openbravo
Revision: 9075
Author: huehner
Date: 2008-10-23 12:36:49 +0200 (Thu, 23 Oct 2008)

Issue 5624
added missing to_number calls to fix problem on pgsql 8.3 with numeric filters

---
U branches/r2.40performance/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Bank_data.xsql
---

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