Turn Marketing Data into Revenue Intelligence. SugarChimp seamlessly syncs your SugarCRM and Mailchimp data in both directions—no manual updates, no stale lists. This real-time connection arms your sales team with richer, more meaningful insights into customer behavior.
#3616 - Sugarchimp table size
I having several problem with sugarchimp. The table of sugarchimpactivity is huge 4.1gb, sugarchimp 3.4gb and sugarchimpactivity_contact 1 gb.
When I try to go to the healt status I have an error message of timeout.
-
"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
7 years ago
Hello there,
The sugarchimpactivity table can grow quite large as we store all MailChimp Activities that come in. The same goes for the sugarchimpactivity_contact table, as it holds those relationships. This is a situation where your client might not care about activities that are a year old from MailChimp, so you can delete those without harming their data. That is something you can ask them about that could help free up some space.
However, the sugarchimp table should be quite small, as it should be our queue of items waiting to be processed. Since this is so large, then I suggest we get on a call together to figure out what could be going wrong. Can you schedule a time for us to meet here: https://calendly.com/fanaticallabs/sugarchimp-support
We should be able to figure out what's going on with that sugarchimp table.
Thanks, Jon
7 years ago
Hello,
I just wanted to update the support case to say that we are finding many scheduler failures in your logs for all of our jobs, as well as the process author jobs. We are going to look over the logs you've sent to us and we have scheduled a second call for Monday morning to look at the state of the integration again.
Thanks for your patience as we debug the issue with your schedulers.
Kind Regards, Jon