diff options
| author | Denis Ledoux <dle@odoo.com> | 2018-11-29 11:33:49 +0000 |
|---|---|---|
| committer | Denis Ledoux <dle@odoo.com> | 2018-11-29 11:46:22 +0000 |
| commit | 9fbac5fcbbec20777a15a46fe17a6eb7e21575d4 (patch) | |
| tree | a432ec0250f4c2bb21923b91ef241a95fbdd5f10 /addons/web/static/tests/fields/basic_fields_tests.js | |
| parent | 8e7c2552371fddcb5cd9ef1e785ec40c37fe8ea0 (diff) | |
[IMP] crm: improve team pipeline dashboard leads/opps counts performance
The team pipeline dashboard fields
`unassigned_leads_count`, `opportunities_count`, `opportunities_amount`
do a big search on leads, filtered
by type (lead/opp), team, and unassigned user_id (salesman)
Adding an index on user_id, team_id, type significantly
improves the filtering, and therefore the dashboard rendering,
especially when displaying a few teams only
e.g; the teams you are part or responsible of.
The index on `user_id` is removed,
as it become a duplicate as `user_id` is the first column
of this new index.
Diffstat (limited to 'addons/web/static/tests/fields/basic_fields_tests.js')
0 files changed, 0 insertions, 0 deletions
