Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 09. Financial managementmajorsometimes2015-12-17 09:342015-12-17 09:34
ReporterioritzCiaView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.6
OS Version14.04Database version9.3Ant version1.7
Product Version3.0PR15Q1.5SCM revision 
Review Assigned To
Web browserGoogle Chrome
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0031740: Report trial balance report is slow with high number of transactions

DescriptionThe Trial Balance report's executions gets too slow and can seriously affect whole system's performance if it has to read a high number of transaction. This happen if the system is big enough or the instance have been running long enough.

This happens because data needs to be read from the beginning of time and a huge reading effort is required from disk.
Steps To ReproduceExecute the report in a system with a huge number of transactions.
Proposed SolutionEverytime the system closes a period, the information from that period should be aggregated and the result should be stored in a table so that the report can read from this table all the old and already calculated information. This way the reading effort decreases a lot and part of the calculation is done only once per period close.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of design defect 0035563 acknowledgedvmromanos Trial Balance report takes long to be printed on xls. 
related to design defect 0036070 acknowledgedTriage Finance Performance problems on the journal entries report. 
related to defect 0040175 scheduledmarkmm82 Trial balance report should not take into account the closed years 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-12-17 09:34 ioritzCia New Issue
2015-12-17 09:34 ioritzCia Assigned To => dmiguelez
2015-12-17 09:34 ioritzCia Web browser => Google Chrome
2015-12-17 09:34 ioritzCia Modules => Core
2015-12-17 09:34 ioritzCia Triggers an Emergency Pack => No
2017-04-18 09:45 vmromanos Relationship added duplicate of 0035563
2017-06-02 12:39 aferraz Relationship added related to 0036070
2019-02-11 12:22 Sandrahuguet Relationship added related to 0040175

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker