diff options
| author | Rémy Voet (ryv) <ryv@odoo.com> | 2020-12-31 09:20:07 +0000 |
|---|---|---|
| committer | Rémy Voet (ryv) <ryv@odoo.com> | 2021-01-21 13:52:41 +0000 |
| commit | cefb14f79185bc135d6717e7ca8dbe5d23856371 (patch) | |
| tree | c4236299f4939afa2dc2a183255f04b1a5563e22 /addons/website_livechat/static/src/components/discuss | |
| parent | a8dd0655b1e318a6940b5dd1708952043349de4e (diff) | |
[FIX] mrp: add indexes on highly search fields
Add two indexes (on `product_id` and `product_tmpl_id`)
on the `mrp.bom` model to speed up `_bom_find`
which is highly used and it uses always the `product_tmpl_id` and
sometime the `product_id` in the search domain.
Performance Gain:
With a DB with 2K BoM, a `_bom_find` search (`product_id` and
`product_tmpl_id` are in domain): The SQL execution time
is +- 5 times faster.
task-2390516
closes odoo/odoo#63922
Signed-off-by: Arnold Moyaux <amoyaux@users.noreply.github.com>
Diffstat (limited to 'addons/website_livechat/static/src/components/discuss')
0 files changed, 0 insertions, 0 deletions
