Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#4807 - db performance issue
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.
-
"Does a great job of syncing all of our registrant information. They go the extra mile with one-on-one support!"
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
a year 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
a year 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.