Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0031740 | Openbravo ERP | 09. Financial management | public | 2015-12-17 09:34 | 2015-12-17 09:34 |
|
| Reporter | ioritzCia | |
| Assigned To | dmiguelez | |
| Priority | normal | Severity | major | Reproducibility | sometimes |
| Status | new | Resolution | open | |
| Platform | | OS | 30 | OS Version | 14.04 |
| Product Version | 3.0PR15Q1.5 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | Google Chrome |
| Modules | Core |
| Support ticket | |
| 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. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | duplicate of | design defect | 0035563 | | acknowledged | vmromanos | Trial Balance report takes long to be printed on xls. | | related to | design defect | 0036070 | | acknowledged | Triage Omni OMS | Performance problems on the journal entries report. | | related to | defect | 0040175 | | scheduled | markmm82 | Trial balance report should not take into account the closed years |
|
| Attached Files | |
|
| 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 |