What can be done to improve loading of Activity searches and tabs on databases with gazillion civicrm_activity_contact rows
I do not know why this is so slow but we developed an extension together with Matthew Wire that improves some of those problems. Information can be found here.