Accounting mailing list archives
accounting@odoo-community.org
Browse archives
Re: Account reconcile speed
by
md-lists
Hi Karl, if Odoo 13 is an option for you, you should give it a try, they improved the ORM performance a lot in 13.0 and as far as i remember avoiding to much recomputing was a big part of it. cheers, Maik Am 05.10.20 um 19:47 schrieb Karl Southern: > Hi, > > First off apologies. I know this probably is not the appropriate forum > for this, but I'm at the point where I've run out of ideas beyond > doing something drastic. > > I've got a client on Odoo 12.0, they invoice each SO separately, and > take large chunk payments - think 1 large payment for maybe 2k or more > invoices. Neither of these things I can change. > > The problem I'm hitting is account.move reconcile takes an absolute > ice age. > > Profiling I can see the ORM kicking off a chain of recomputes down the > tree, it seems to then invalidate the relevant caches and reload what > seems to be the entire recordset of moves from the DB. > > Throwing it onto a job queue does not really help, it just masks the > problem (last run was creeping towards 4 hours), and if there's a > serialisation issue then the job is screwed. > > What I'm hoping for is a rough pointer or suggestion of how to deal > with this, or maybe there's something I've overlooked? I'm at the > point where I'm considering all options, including stupid ones. > > Thanks in advance, > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/accounting-28 > <https://odoo-community.org/groups/accounting-28> > Post to: mailto:accounting@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe > <https://odoo-community.org/groups?unsubscribe> > -- viele Grüße Maik Derstappen derico - web development & consulting >> Python - Plone - Odoo - Pyramid - Django Maik Derstappen - Geschäftsführer Calvisiusstr. 3 - 04177 Leipzig - Deutschland Tel: +49 178 861 2 833 - +49 341 126 951 71 - E-Mail: md@derico.de - Web: http://derico.de -- help -- Ask your Plone questions on Gitter: https://gitter.im/plone/public
