diff options
| author | Rémy Voet (ryv) <ryv@odoo.com> | 2021-05-05 08:41:20 +0000 |
|---|---|---|
| committer | Rémy Voet (ryv) <ryv@odoo.com> | 2021-05-05 13:23:36 +0000 |
| commit | e0bafb0715a270b1032647474bde40ca680beff4 (patch) | |
| tree | f20138888a8165413ddfdba8f34c7c04ea733020 /addons/web/tests | |
| parent | 722fba2313bae3f2825492a3822111bbb25332b7 (diff) | |
[FIX] stock: fix broken forecasted report template
Remove the optimization of the `product_tmpl_id` related fields which
needs a upgrade to work without any issues.
This reverts partially the commit
4c62765195a6410da1c4e74c0f1a0fcf57c38e97.
Find a other for the stable to optimise the forecasted report of product
template:
When the `product_tmpl_id` is in the domain of a read_group, it will
be replace by a equivalent clause with `product_id` instead to avoid
any sub-query which didn't help the postgreSQL planner.
The performance decrease but it still acceptable compared that before
the revert fix (test with one template with 256 variants in
a DB with 40K products and 100K moves, 1K locations, etc)
- Revert fix (which need a upgrade): 75 ms
- new fix (no need a upgrade): 130 ms
- without any fixes (before the revert fix): 500 ms (also have a bigger
scale penalty)
closes odoo/odoo#70381
Signed-off-by: Arnold Moyaux <amoyaux@users.noreply.github.com>
Diffstat (limited to 'addons/web/tests')
0 files changed, 0 insertions, 0 deletions
