summaryrefslogtreecommitdiff
path: root/doc/setup
diff options
context:
space:
mode:
authorDenis Ledoux <dle@odoo.com>2018-11-29 11:33:49 +0000
committerDenis Ledoux <dle@odoo.com>2018-11-29 11:46:22 +0000
commit9fbac5fcbbec20777a15a46fe17a6eb7e21575d4 (patch)
treea432ec0250f4c2bb21923b91ef241a95fbdd5f10 /doc/setup
parent8e7c2552371fddcb5cd9ef1e785ec40c37fe8ea0 (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 'doc/setup')
0 files changed, 0 insertions, 0 deletions