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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
