AnsweredAssumed Answered

Sugar server getting down in outlook Sync query

Question asked by pavan agrawal on Oct 30, 2018
Latest reply on Nov 23, 2018 by pavan agrawal

Hello Team,


I don't know but when I logged in SugarCRM application using chrome mobile then multiple query is running on server for each module such as Notes, Contacts, Opportunities, Accounts.


Query Sample in Contacts -


SELECT DISTINCT id, contacts.date_modified date_modified FROM contacts  LEFT JOIN contacts_cstm ON = contacts_cstm.id_c   LEFT JOIN  users jt0 ON AND jt0.deleted=0


 AND jt0.deleted=0  LEFT JOIN  users jt1 ON AND jt1.deleted=0


 AND jt1.deleted=0  LEFT JOIN  accounts_contacts jtl2 ON AND jtl2.deleted=0
 AND jtl2.primary_account = 1
 LEFT JOIN  accounts accounts ON AND accounts.deleted=0
 AND accounts.deleted=0   LEFT JOIN  accounts_contacts jtl3 ON AND jtl3.deleted=0
 AND jtl3.primary_account = 1
 LEFT JOIN  accounts jt3 ON AND jt3.deleted=0
 AND jt3.deleted=0   LEFT JOIN  opportunities_contacts opportunities_contacts ON AND opportunities_contacts.deleted=0


 LEFT JOIN  opportunities jt4 ON AND jt4.deleted=0
 AND jt4.deleted=0   LEFT JOIN  contacts jt5 ON AND jt5.deleted=0


 AND jt5.deleted=0  LEFT JOIN  campaigns jt6 ON AND jt6.deleted=0


 AND jt6.deleted=0  LEFT JOIN  calls_contacts jtl7 ON AND jtl7.deleted=0


 LEFT JOIN  calls jt7 ON AND jt7.deleted=0
 AND jt7.deleted=0   LEFT JOIN  meetings_contacts jtl8 ON AND jtl8.deleted=0


 LEFT JOIN  meetings jt8 ON AND jt8.deleted=0
 AND jt8.deleted=0  LEFT JOIN tag_bean_rel jt9
                                     AND jt9.deleted=0 LEFT JOIN tags jt10
                                     AND jt9.deleted=0  LEFT JOIN  users jt11 ON AND jt11.deleted=0


 AND jt11.deleted=0  LEFT JOIN  team_sets ts1 ON AND ts1.deleted=0


 AND ts1.deleted=0  LEFT JOIN  teams tj ON AND tj.deleted=0


 AND tj.deleted=0 where contacts.deleted=0 ORDER BY contacts.date_modified DESC, DESC LIMIT 0,20



Please suggest how and when these type query runs. Thanks!