account - Legal Statements - General Ledger Performance issue [memory leak?]
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
KDE OpenObject Client |
New
|
Wishlist
|
Unassigned | ||
Odoo Addons (MOVED TO GITHUB) |
Fix Released
|
High
|
Jay Vora (Serpent Consulting Services) |
Bug Description
The General Ledger report generation is too slow, leading to a "timeout" on the client side if there are too many records (1000 are enough), making it impossible to print the general ledger without using 'workarounds' (printjob module), and even then it uses all the CPU for too long making the server irresponsible.
***
Times reported by Ferdinand @ ChriCar:
About 3700 account move lines for 5 years (very small company) it takes
* 1:40 min to print General Ledger for all 5 years (60 pages 3700 records)
* 0:30 min to print GL for period 200912 (6 pages, 120 records)
***
Times reported by Borja López Soilán:
Tested on a Core2Duo 4400@2Ghz with 2GB RAM.
Created a new demo database (service profile), and then used a script to create 10.000 account moves.
It took about 35 minutes to generate the general ledger report (the client did timeout after 3 minutes):
* 30m of CPU time consumed by Python
* 1m30s of CPU time consumed by Postgres
Notes:
* Some queries related with the RML translation (formatLang function), may be cached to save up to 30% of the Postgres time. For example, this single query is done 160.000 times, taking 38.9 seconds: "SELECT date_format"
* 10.000 account moves take 30m, so everything with more than 1000 account moves would give a timeout on the client side.
Related branches
Changed in openobject-client-kde: | |
importance: | Undecided → Wishlist |
Changed in openobject-addons: | |
status: | New → Confirmed |
assignee: | nobody → Anup (Open ERP) (ach-openerp) |
Changed in openobject-addons: | |
status: | Confirmed → In Progress |
Changed in openobject-addons: | |
assignee: | Anup (Open ERP) (ach-openerp) → Jay (Open ERP) (jvo-openerp) |
Changed in openobject-addons: | |
milestone: | none → 5.0.13 |
A Dissabte, 30 de gener de 2010, Ferdinand @ ChriCar va escriure:
> Public bug reported:
>
> about 3700 account move lines for 5 years (very small company)
> it takes
> * 1:40 min to print General Ledger for all 5 years (60 pages 3700 records)
> * 0:30 min to print GL for period 200912 (6 pages, 120 records)
>
> during this the terminal is blocked
>
> alternate solutions are needed !!!
printjob module in community works very well
> client- kde
> ** Affects: openobject-
> Importance: Undecided
> Status: New
>
-- www.NaN- tic.com
Albert Cervera i Areny
http://
Mòbil: +34 669 40 40 18