Created on 2021-12-08.17:00:51 by ced, last changed 9 months ago by roundup-bot.
New changeset deb1e35c6ddb by Cédric Krier in branch 'default': Use SQL queries to check if move lines are balanced https://hg.tryton.org/tryton-env/rev/deb1e35c6ddb
New changeset 5a15561b28ce by Cédric Krier in branch 'default': Use SQL queries to check if move lines are balanced https://hg.tryton.org/modules/account/rev/5a15561b28ce
I measured that the creation of 30K lines before it spent more than 10 hours (I stopped when it was at 20K) and after it takes 10 minutes.
For a migration I'm importing using proteus the account balances which is a move with about 20K lines. In proteus I create the lines per group of 1000 lines to optimize the cache usage. But this is still very slow. I think the main issue is the Move.validate_move which browses all the move lines to compute the balance.
I think it will be better to perform this operation with SQL only.
The same applies to the check in Move.post which check also that lines are balanced.
|2021-12-21 23:28:30||roundup-bot||set||messages: + msg72875|
nosy: + roundup-bot
status: testing -> resolved
|2021-12-08 21:25:22||ced||set||messages: + msg72054|
nosy: + reviewbot
status: in-progress -> testing