by Fanatical Labs

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.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#3767 - Database index for sugarchimp_mc_list table

Closed Bug? created by dwangerin 4 years ago

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

  1. fanatical_jon member avatar

    Jon S Provider

    4 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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "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