SugarChimp

Hi, we are getting a db performance issue with sugarchimp which is causing page loads within our CRM to be very slow. Looking at our db I can see that a number of queries are hitting the db regularly and each are taking 15 to 30 seconds to complete. Such a query is:- SELECT id AS activity_id FROM sugarchimpactivity WHERE name LIKE 'xxxxxxxx' AND activity = 'open' AND mailchimp_list_id = 'dea0c32026' AND mailchimp_campaign_id = '92b620cb68' AND timestamp = '2023-01-09 16:55:57' ORDER BY date_entered DESC Our sugarchimpactivity table has about 500,000 rows and running such a query manually in the mysql client shows a response of 38 seconds - so looks like it might be doing a full table scan. Looking at the db via 'show processlist' often shows that between 25 to 50 of these queries are running at the same time and so have a big impact on performance. What can we do to fix this performance problem? Thanks.