Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009241 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-05-29 12:53 | 2009-06-30 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | immediate | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP3 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009241: The general ledger journal gets very slow when lots of journal are in the system. | |||||||
| Description | The general ledger journal gets very slow when lots of journal are in the system. | |||||||
| Steps To Reproduce | -Go to a application with lots of journal -Enter filters to show all the informatino of the journal -Print de report -It takes many time to show the report. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0016771) rafaroda (developer) 2009-05-29 16:10 edited on: 2009-06-16 12:33 |
David, Could you please determine whether this issue has to be assigned to Performance team? Thank you. |
|
(0016786) dalsasua (reporter) 2009-06-01 08:41 |
It's needed that reporter specifies what does "lots" mean: one hundred, one thousand, a hundred thousand, one million, one thousand millions, one trillion? Moreover, if the problem is to have "lots" of rows in the fact_acct table (so number of entries -posted documents- in the system), if the problem is that "lots" of rows must be shown in the report (so length of the report), or if the problem is other one? Thanks. Regards. |
|
(0016892) azabaleta (developer) 2009-06-02 22:51 |
5 million entries in fact_Acct table. There are 2 different problems. 1.- When clicking in the menu on General Ledger Journal, the report is executed. It shouldnt. It should show the filters, and the user should execute it when wanted. 2.- Once the filters are selected, it is still very slow although only shows +-journals in the first page of the report. Showing that should be instantaneous. Regards. |
|
(0017616) dalsasua (reporter) 2009-06-26 14:47 |
Problem 1 fixed in issue 0009242 |
|
(0017651) networkb (developer) 2009-06-29 19:41 |
it was not a performance issue but an issue related to the accounting background process |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-05-29 12:53 | networkb | New Issue | |
| 2009-05-29 12:53 | networkb | Assigned To | => rafaroda |
| 2009-05-29 16:10 | rafaroda | Note Added: 0016771 | |
| 2009-05-29 16:10 | rafaroda | Assigned To | rafaroda => dalsasua |
| 2009-06-01 08:41 | dalsasua | Note Added: 0016786 | |
| 2009-06-01 08:41 | dalsasua | Status | new => feedback |
| 2009-06-02 22:51 | azabaleta | Note Added: 0016892 | |
| 2009-06-02 22:51 | azabaleta | Issue Monitored: azabaleta | |
| 2009-06-03 08:41 | pnuding | Status | feedback => new |
| 2009-06-04 16:40 | dalsasua | Status | new => scheduled |
| 2009-06-04 16:40 | dalsasua | fix_in_branch | => pi |
| 2009-06-16 12:33 | rafaroda | Note Edited: 0016771 | |
| 2009-06-26 14:45 | dalsasua | Relationship added | related to 0009242 |
| 2009-06-26 14:47 | dalsasua | Note Added: 0017616 | |
| 2009-06-29 19:41 | networkb | Relationship added | duplicate of 0009560 |
| 2009-06-29 19:41 | networkb | Status | scheduled => closed |
| 2009-06-29 19:41 | networkb | Note Added: 0017651 | |
| 2009-06-29 19:41 | networkb | Duplicate ID | 0 => 9560 |
| 2009-06-29 19:41 | networkb | Resolution | open => duplicate |
| 2009-06-30 00:00 | anonymous | sf_bug_id | 0 => 2814264 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |