diff options
| author | Florian da Costa <florian.dacosta@akretion.com> | 2018-08-22 11:51:22 +0200 |
|---|---|---|
| committer | William Henrotin <whe@odoo.com> | 2018-08-22 11:53:56 +0200 |
| commit | 2bcb1b1ca51403448fcc73135e28e497cb24cc99 (patch) | |
| tree | 6e2239d8d7b0dae1d83c384fb8b1720138beb9d5 /doc | |
| parent | f201e720c4960d561e21462f8ffd7bf651957380 (diff) | |
[PERF] stock: states 'not it' values changed to 'in' opposite.
Purpose: databases with lots of stock moves (3M+) can experience
slowness
when computing quantities on hand and forecasted.
Before this commit, the domains built to compute those quantities from
stock_move contained (state not in [done, cancel, draft]). Done and
cancel states represent around 95-99% of stock_moves in a normal
instance. So selecting all stock_moves then removing done and cancel
ones if truly less efficient than taking directly the 'waiting',
'assigned', ... moves especially that the state in indexed in database.
After this commit, the domain is build with :
(state in [...]) with other state than 'done, 'cancel' and draft.
This commit is related to the PR 23030. Thanks to all people that have
took part of the conversation and florian-dacosta for the commit
Diffstat (limited to 'doc')
0 files changed, 0 insertions, 0 deletions
