by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Cancel at any time!
Free Trial

#3767 - Database index for sugarchimp_mc_list table

In Progress Bug? created by dwangerin a year 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

    a year 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...
Rating
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.