Windows XP and Vista
Sugar 5.2.0
Apache 2.2.4
PHP: 5.2.3-1ubuntu6.3
MySQL Server: 5.0.45-1ubuntu3.3

I have some trouble with the contacts home page/search area. The page takes over 20 seconds to load at times and searches take anywhere from 15 - 20 seconds. This particular query that has to run for the page to load seems to be slowing things down:
Code:
SELECT count(*) c FROM contacts   LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c   LEFT JOIN  accounts_contacts jtl0 ON contacts.id=jtl0.contact_id  AND jtl0.deleted=0
LEFT JOIN  accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0
AND accounts.deleted=0  LEFT JOIN  users jt1 ON
jt1.id= contacts.assigned_user_id AND jt1.deleted=0
AND jt1.deleted=0 where contacts.deleted=0;
I can't figure out what about this query would slow things down, but when I turn on MySQL slow logging to capture queries that are running slowly the above query ends up in the log when I load the contactspage. So it has to be slowing things down for some reason.

Has anyone else experienced this? Any suggestions?

jcb23