summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorFlorian da Costa <florian.dacosta@akretion.com>2018-08-22 11:51:22 +0200
committerWilliam Henrotin <whe@odoo.com>2018-08-22 11:53:56 +0200
commit2bcb1b1ca51403448fcc73135e28e497cb24cc99 (patch)
tree6e2239d8d7b0dae1d83c384fb8b1720138beb9d5 /doc
parentf201e720c4960d561e21462f8ffd7bf651957380 (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