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 Sell & Enterprise. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#3767 - Database index for sugarchimp_mc_list table
Hi SugarChimp Team,
Our Operations team noticed a missing index that can cause database performance issues. The following index has to be added in order to prevent this:
ALTER TABLE sugarchimp_mc_list ADD index `idx_mailchimp_list_id`(`mailchimp_list_id`);
Can you add that index on installation in order to prevent performance issues?
Let me know in case you need further information.
Thanks,
Dennis
SugarCRM Support
-
"We do a lot of highly-segmented outbound marketing and SugarChimp is exactly what we needed. The list and field syncing are great, and it allows us to do more sophisticated campaigns that exactly target certain Lead profiles in Sugar. The SugarChimp team is also really great, and they are totally committed to our success."
Read More Reviews
6 years ago
Hello Dennis,
We are working on the package that will resolve this issue as it's come up a couple of times now. We've got another table that needs an index added - sugarchimpactivity, which we've included in the package as well. Our current hesitation in releasing the package is that the index seems to timeout when running through the installer. The package installs correctly on smaller tables, but fails with our larger ones. Is there any fallout if we add the index to the package but it fails to install on some of our larger clients OD instances?
Is there a way for us to be notified when one of the indexes fail so that your team can add the index directly?
Thanks, Jon