Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009241Openbravo ERP09. Financial managementpublic2009-05-29 12:532009-06-30 00:00
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS30OS Version
Product Version2.40MP3 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009241: The general ledger journal gets very slow when lots of journal are in the system.
DescriptionThe 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0009560 closed eduardo_Argal The background process goes to a infinite loop when the partner has not a account on the accoounting tab. 
related to defect 0009242 closed dalsasua When entering in the Generl Ledger Journal report the report shouldn't be executed automatically 
depends on backport 0009337 closed dalsasua The general ledger journal gets very slow when lots of journal are in the system. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-29 12:53networkbNew Issue
2009-05-29 12:53networkbAssigned To => rafaroda
2009-05-29 12:53networkbOBNetwork customer => Yes
2009-05-29 16:10rafarodaNote Added: 0016771
2009-05-29 16:10rafarodaAssigned Torafaroda => dalsasua
2009-06-01 08:41dalsasuaNote Added: 0016786
2009-06-01 08:41dalsasuaStatusnew => feedback
2009-06-02 22:51azabaletaNote Added: 0016892
2009-06-02 22:51azabaletaIssue Monitored: azabaleta
2009-06-03 08:41pnudingStatusfeedback => new
2009-06-04 16:40dalsasuaStatusnew => scheduled
2009-06-04 16:40dalsasuafix_in_branch => pi
2009-06-16 12:33rafarodaNote Edited: 0016771
2009-06-26 14:45dalsasuaRelationship addedrelated to 0009242
2009-06-26 14:47dalsasuaNote Added: 0017616
2009-06-29 19:41networkbRelationship addedduplicate of 0009560
2009-06-29 19:41networkbStatusscheduled => closed
2009-06-29 19:41networkbNote Added: 0017651
2009-06-29 19:41networkbDuplicate ID0 => 9560
2009-06-29 19:41networkbResolutionopen => duplicate
2009-06-30 00:00anonymoussf_bug_id0 => 2814264

Notes
(0016771)
rafaroda   
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   
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   
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   
2009-06-26 14:47   
Problem 1 fixed in issue 0009242
(0017651)
networkb   
2009-06-29 19:41   
it was not a performance issue but an issue related to the accounting background process