Turn Marketing Data into Revenue Intelligence. SugarChimp seamlessly syncs your SugarCRM and Mailchimp data in both directions—no manual updates, no stale lists. This real-time connection arms your sales team with richer, more meaningful insights into customer behavior.
#4807 - db performance issue
Closed
Bug?
created by UA Professional Services Spain SL (ESB42725150) Verified Purchase 2 years ago
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.
2 years ago
Thanks for reaching out. I chatted with our developer and I think it might be fastest to hop on a call to take a closer look. Can you find some time that works for you here: https://calendly.com/fanaticallabs_support/sugarchimp-support-meeting
If you'd rather work through email, let me know!
Best, Heidi
2 years ago
Although we've worked through email, I wanted to quickly follow up on this ticket in case anyone else comes across the same issue.
We've released a new version that addresses this issue. Please update to the latest version and run a Quick Repair and Rebuild. Let us know if you have any issues at mailchimp@fanaticallabs.com.