Accounting mailing list archives

accounting@odoo-community.org

Avatar

Re: Account reconcile speed

by
md-lists
- 27/10/2020 11:02:53
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



Reference