summaryrefslogtreecommitdiff
path: root/addons/web/tests
diff options
context:
space:
mode:
authorRémy Voet (ryv) <ryv@odoo.com>2021-05-05 08:41:20 +0000
committerRémy Voet (ryv) <ryv@odoo.com>2021-05-05 13:23:36 +0000
commite0bafb0715a270b1032647474bde40ca680beff4 (patch)
treef20138888a8165413ddfdba8f34c7c04ea733020 /addons/web/tests
parent722fba2313bae3f2825492a3822111bbb25332b7 (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