summaryrefslogtreecommitdiff
path: root/addons/mail/static/src/components/autocomplete_input
diff options
context:
space:
mode:
authorRémy Voet (ryv) <ryv@odoo.com>2021-01-05 10:48:12 +0000
committerRémy Voet (ryv) <ryv@odoo.com>2021-01-21 13:52:32 +0000
commita8dd0655b1e318a6940b5dd1708952043349de4e (patch)
tree06e2e8b2b61ad7fc72c74268203d39039d0c2343 /addons/mail/static/src/components/autocomplete_input
parent7dece58f1116e2ae669f7282bffb30cddf3d7624 (diff)
[FIX] stock: improve performance of `report.stock.quantity`
Use UNION ALL instead of UNION to let PostgreSQL filter out rows before sorting and avoid Unique check. Note that it shouldn't change the result because each 3 SELECT doesn't have domain intersection. Improve performance the `_get_orderpoint_action` and the Forecasted Inventory. Performance Gain: With a large Database (5K products, 120K stock move, 20K quants, etc): To open the Forecasted Inventory: Before: 10.06 sec +- 0.02 After: 3.98 sec +- 0.07 task-2390516
Diffstat (limited to 'addons/mail/static/src/components/autocomplete_input')
0 files changed, 0 insertions, 0 deletions