Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0024723
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2013-09-09 18:282013-09-23 10:27
ReporteregoitzView Statuspublic 
Assigned Topramakrishnan 
PriorityurgentResolutionfixedFixed in Version3.0MP28
StatusclosedFix in branchFixed in SCM revision641fafa51870
ProjectionnoneETAnoneTarget Version3.0MP28
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toegoitz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024723: Performance problem when opening a row on the transacctions tab on the financial account window

DescriptionWhen there are a lot of payments on the application when opening a transaction row on the financial account window it takes long to load the data.

The problem is tha fin_payment_id field:

- Warning: In the window Financial Account, in tab Transaction the combo fields inpfinPaymentId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
Steps To Reproduce-ON an application with more than 1000 payments open a row on the transaction tab, on the financial account window.

It takes long to load and on the log you get the following message:

- Warning: In the window Financial Account, in tab Transaction the combo fields inpfinPaymentId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
Proposed Solution-Change the reference to OBUISelector Reference, and the reference search key to Payment Selector
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of defect 00243643.0MP29 closedcaristu Payment selector in Financial account - Transaction window is causing performance problems 

-  Notes
(0061162)
hgbot (developer)
2013-09-15 12:04

Repository: erp/devel/pi
Changeset: 641fafa5187050c3e105d564f5c13e445e35b499
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Sun Sep 15 15:32:37 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/641fafa5187050c3e105d564f5c13e445e35b499 [^]

Fixes Issue 24723: Performance problem in transactions tab in financial account

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0061253)
hudsonbot (developer)
2013-09-17 19:03

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/1c53d622fc50 [^]

Maturity status: Test
(0061345)
egoitz (developer)
2013-09-23 10:27

verified

- Issue History
Date Modified Username Field Change
2013-09-09 18:28 egoitz New Issue
2013-09-09 18:28 egoitz Assigned To => AugustoMauch
2013-09-09 18:28 egoitz Modules => Core
2013-09-09 18:28 egoitz Triggers an Emergency Pack => No
2013-09-09 18:32 egoitz Tag Attached: Performance
2013-09-10 08:31 alostale Assigned To AugustoMauch => dmiguelez
2013-09-15 12:00 pramakrishnan Assigned To dmiguelez => pramakrishnan
2013-09-15 12:03 pramakrishnan Review Assigned To => egoitz
2013-09-15 12:03 pramakrishnan Status new => scheduled
2013-09-15 12:04 hgbot Checkin
2013-09-15 12:04 hgbot Note Added: 0061162
2013-09-15 12:04 hgbot Status scheduled => resolved
2013-09-15 12:04 hgbot Resolution open => fixed
2013-09-15 12:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/641fafa5187050c3e105d564f5c13e445e35b499 [^]
2013-09-17 19:03 hudsonbot Checkin
2013-09-17 19:03 hudsonbot Note Added: 0061253
2013-09-23 10:27 egoitz Note Added: 0061345
2013-09-23 10:27 egoitz Status resolved => closed
2013-09-23 10:27 egoitz Fixed in Version => 3.0MP28
2013-10-21 12:56 caristu Relationship added duplicate of 0024364


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker