[10.0]account_analytic_parent. Debit, credit and balance computation is super slow.

[AaronHForgeFlow]

When overriding the method that computes those fields here: https://github.com/OCA/account-analytic/blob/10.0/account_analytic_parent/models/account_analytic_account.py#L24 Odoo calls the same method for all the children and it gets extremely slow when the number of analytic accounts grow, specially with many children.

We can make those fields stored but then we have to make sure it is recomputed everytime its needed and it's complex.

Any ideas are welcome! 🤗

[pedrobaeza]

Use read_group for computing them. Your colleague @mreficent made something similar in contracts.

[AaronHForgeFlow]

Ok thanks, @mreficent can you point me to that change? I could not find it in contracts.

[MiquelRForgeFlow]

OCA/contract@402370f#diff-3dc0d52ea9449a93459ef5b7fc36a060R19

[AaronHForgeFlow]

Thanks @mreficent

[AaronHForgeFlow]

Cannot group_by non stored fields. And read group does not return the values that are not in the group_by. I'll go for a query instead.

edit:I can read_group the analytic lines but that would be duplicating the core method

[pedrobaeza]

@aheficent this has nothing to do with stored/non stored. Please use read_group properly.

[AaronHForgeFlow]

Do you mean to read_group in the analytic lines and not call super instead?
update: I think I got it...

[pedrobaeza]

Well, you limit the read_group in the domain to the self.ids scope.