Community mailing list archives

community@mail.odoo.com

CRM Sales Team shared Leads (performance)

by
initOS GmbH, Torsten Francke
- 09/08/2014 08:52:10
Hi everyone,

we have one project, where sales teams share together leads in a sales
team. This is possible with "crm.case.section" in OpenERP v7 you need to
change the rights that you can see all leads that in your section but
you are not the responsible salesman. This works really fine, but the
performance gets more and more worse.
We have only 2k open crm.leads with 10 teams and 25 salesman, that not
that much i think.
We play around with some auto_join but this breaks some domains or is
incompatible with the search.

I try to look for odoo v8 [1] how sales_team should correct implemented
that multiple people can share leads and see only the one of his own
salesteam. But it looks like the rights are not really implemented as
you aspect. (sidemark: so the screenshot of sales teams are only candy
marketing for new Odoo Version [2])

Has someone experience and some hint to speed up domains like:
(section_id.member_ids','child_of',user.id)

As we see in the postgres logs openerp pulls first ids and reuse it
later for the next query instead of building joins (or subsulects).

Kind Regards

Markus



[1]
https://github.com/odoo/odoo/blob/8.0/addons/crm/security/crm_security.xml
[2] https://twitter.com/Odoo/status/507444724090032128

-- 
Dipl.-Comp.-Math. Markus Schneider
Softwareentwickler

initOS GmbH & Co. KG
An der Eisenbahn 1
21224 Rosengarten

Mobil:   +49 (0)172 2303699
Phone:   +49 (0)4105 5615613
Fax:     +49 (0)4105 5615610

Email:   markus.schneider@initos.com
Web:     http://www.initos.com

Geschäftsführung:
Dipl. Wirt.-Inf. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
Haftende Gesellschafterin: initOS Verwaltungs GmbH

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRA 201840
USt-IdNr: DE 275698169
Steuer-Nr: 15/205/21402