0009241: The general ledger journal gets very slow when lots of journal are in the system.

Notes
(0016771) rafaroda (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 2009-06-26 14:47	Problem 1 fixed in issue 0009242

(0017651) networkb (viewer) 2009-06-29 19:41	it was not a performance issue but an issue related to the accounting background process