diff options
| author | Denis Ledoux <dle@odoo.com> | 2018-11-29 11:40:24 +0000 |
|---|---|---|
| committer | Denis Ledoux <dle@odoo.com> | 2018-11-29 11:46:22 +0000 |
| commit | 5644ab53ab6f370a2fb48242e22702655afd6655 (patch) | |
| tree | c33b070e224a81dc7e531a724c3fb23d31ea1b2e /addons/web/static/tests/fields/basic_fields_tests.js | |
| parent | 9fbac5fcbbec20777a15a46fe17a6eb7e21575d4 (diff) | |
[FIX] sale: improve team pipeline dashboard quotation counts performance
Doing the `read_group` on `sale.order` rather than
`sale.report` to get the quotations amount and count
significantly improve the performance (5x faster on big databases).
This is because `sale.report` is a view,
with a bunch of fields taking time to compute / fetch.
Besides, the algorithm to get the number of quotations
was an heuristic based on the "group by name" on the `sale.report`,
which was not as precise,
as multiple quotations could potentially have the same name,
and slowed down the query,
because it returned one line per quotation,
versus one line per team with this revision.
closes odoo/odoo#29139
Diffstat (limited to 'addons/web/static/tests/fields/basic_fields_tests.js')
0 files changed, 0 insertions, 0 deletions
