Accounting mailing list archives
accounting@odoo-community.org
Browse archives
RE: Account reconcile speed
by
Kevin McMenamin
Was definitely an issue in previous version s- we ended up using SQL to do the updates of reconciled items which did help – but we were dealing with a payment matched to say 100 invoices
From: Maik Derstappen <md-lists@derico.de>
Sent: Tuesday, 27 October 2020 11:07 PM
To: Accounting <accounting@odoo-community.org>
Subject: Re: Account reconcile speed
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
_______________________________________________
Mailing-List:
https://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe:
https://odoo-community.org/groups?unsubscribe
