Accounting mailing list archives
accounting@odoo-community.org
Browse archives
Account reconcile speed
by
Glodo, 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,
