openerp-expert-accounting team mailing list archive

[Ferdinand Gassauer <office@xxxxxxxxxx>]

On Wednesday 26 May 2010 17:49:19 Antony Lesuisse wrote:
> On 05/26/2010 11:25 AM, Ferdinand Gassauer wrote:
>  > Am Freitag 21 Mai 2010, 11:24:17 schrieb Antony Lesuisse:
>  >> I'm working on the accouting reports, the first issue was the
>  >> performance of the general ledger report.
>  > 
>  > IMHO also c2c and OpenERP are working on this issue
>  > 
>  > for the RML engine itself pls see
>  > https://bugs.launchpad.net/bugs/581800
>  > a solution to this will boost performance
> 
> The problem is the rml and pdf engine (report lab code), not database
> access as you can see in the latest profile below for 320 move_lines on an
> atom cpu (of course this is much faster on a Core2Duo).
did you try 
self.cr.sql_log = True
+ server in debug mode ?

I got a translate sql query for each cell of the report as described in
https://bugs.launchpad.net/openobject-server/+bug/581800
in the postgres pg_log directory
-- 
regards
Ferdinand Gassauer
ChriCar Beteiligungs- und Beratungs- GmbH
Official OpenERP Partner