slow performance caused by emails_text and calls_users in SuiteCRM 7.8.3

💬 General Discussion
1

HI,

we are facing most time consuming queries in production

SELECT calls.* FROM calls_users,calls WHERE ((calls.date_start >= ? AND calls.date_start < ?) OR (calls.date_start < ? AND calls.date_end > ?) AND calls_users.accept_status != ?) AND calls_users.call_id=calls.id AND calls_users.user_id=? AND calls.deleted=? AND calls_users.deleted=?

SELECT from_addr, reply_to_addr, to_addrs, cc_addrs, bcc_addrs, description, description_html, raw_source FROM emails_text WHERE email_id = ?

above queries are triggering 1200 times in 30 min with 125sec time and having proper indexing.

2448807 records are there in calls and calls_users table

please suggest to improve performance at application level.

Regards,
Vijay Kanugonda.