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.
#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
-
"This plugin basically functions as it says it does. Very fast to respond and very thorough in their work. I respect that."
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
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