openerp-india team mailing list archive

["Yannick Vaucher @ Camptocamp" <1311087@xxxxxxxxxxxxxxxxxx>]

** Also affects: ocb-addons
   Importance: Undecided
       Status: New

** Also affects: ocb-addons/7.0
   Importance: Undecided
       Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to Odoo Addons.
https://bugs.launchpad.net/bugs/1311087

Title:
  mail: 'Send a message' generates excessively slow queries

Status in OpenERP Community Backports (Addons):
  New
Status in OpenERP Community Backports (Addons) 7.0 series:
  New
Status in Odoo Addons:
  New

Bug description:
  Using the "Send a message" action on a model having a mail.thread, I
  notice a very long delay (8-10 seconds) before the action is done.

  I used the debug_sql log level and could see that this slowness is due
  to the queries generated by the ORM.

  In the `mail_message` module, in `mail_message._notify`, we can see
  this query:

              fol_ids = fol_obj.search(cr, SUPERUSER_ID, [
                  ('res_model', '=', message.model),
                  ('res_id', '=', message.res_id),
                  ('subtype_ids', 'in', message.subtype_id.id)
                  ], context=context)

  Which results in:
  2014-04-22 14:00:05 CEST LOG:  duration: 1138.682 ms  statement: SELECT "mail_followers_id" FROM "mail_followers_mail_message_subtype_rel" WHERE "mail_message_subtype_id" IN (1)
  2014-04-22 14:00:21 CEST LOG:  duration: 2544.561 ms  statement: SELECT "mail_followers".id FROM "mail_followers" WHERE ((("mail_followers"."res_model" = 'crm.claim')  AND  ("mail_followers"."res_id" = 894))  AND  ("mail_followers"."id" in (1,2,3,4,5, .....))) ORDER BY "mail_followers"."id"
  where (1,2,3,4,5, .....) contains the IDs returned by the first statement (2.500.000 ids here).

  Same result could be done with a query using JOINs:

  SELECT mail_followers.id
  FROM mail_followers
  INNER JOIN mail_followers_mail_message_subtype_rel rel
  ON rel.mail_followers_id = mail_followers.id
  WHERE mail_followers.res_model = 'crm.claim'
  AND  mail_followers.res_id = 894
  AND rel.mail_message_subtype_id = 1
  ORDER BY mail_followers.id

  Then, it takes merely a millisecond instead of several seconds.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ocb-addons/+bug/1311087/+subscriptions