General ledger: very long to generate
Printing general ledger is very long.
On a test database, for 21819 account move lines and 7 accounts, report data are generated in 35 seconds.
On a pre-production database, for 21735 account move lines and 913 accounts , report data are generated in 12 minutes and 58 seconds.
With some work, we have easily decreased the number of accounts (most of accounts have no lines, because migration is not finished), while keeping the same number of account move lines. In this case, report data are generated in 58 seconds.
Those results are for tryton 1.4, with some patches backported from development branch of account module (changesets be90e2906108, b76372879e72 and 43675304b84c).
Before, on the basis of a regular account 1.4 module, data generation for 21735/913 has needed more than one hour.
ODT rendering is not dependant of account numbers. Rendering time for about 800 pages is between 6 and 7 minutes on a Core2Duo / 3Gb RAM server; PDF conversion is done in 10 minutes (we have observed a peak to 30 minutes during our tests).
Files
Download | Creator | Timestamp | Type |
---|---|---|---|
general_ledger.odt | @fares | 2011-12-19 10:11:20.447000 UTC | application/vnd.oasis.opendocument.text |