diff options
| author | Rémy Voet (ryv) <ryv@odoo.com> | 2021-01-05 10:48:12 +0000 |
|---|---|---|
| committer | Rémy Voet (ryv) <ryv@odoo.com> | 2021-01-21 13:52:32 +0000 |
| commit | a8dd0655b1e318a6940b5dd1708952043349de4e (patch) | |
| tree | 06e2e8b2b61ad7fc72c74268203d39039d0c2343 /addons/mail/static/src/components/notification_request | |
| parent | 7dece58f1116e2ae669f7282bffb30cddf3d7624 (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/notification_request')
0 files changed, 0 insertions, 0 deletions
