Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0031740 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] 09. Financial management | major | sometimes | 2015-12-17 09:34 | 2015-12-17 09:34 | |||||||
| Reporter | ioritzCia | View Status | public | |||||||||
| Assigned To | dmiguelez | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6 | |||||||
| OS Version | 14.04 | Database version | 9.3 | Ant version | 1.7 | |||||||
| Product Version | 3.0PR15Q1.5 | SCM revision | ||||||||||
| Review Assigned To | ||||||||||||
| Web browser | Google Chrome | |||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0031740: Report trial balance report is slow with high number of transactions | |||||||||||
| Description | The 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 Reproduce | Execute the report in a system with a huge number of transactions. | |||||||||||
| Proposed Solution | Everytime 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |