#4644 - SugarChimp table - multiple records for the same contact
I'm trying to debug slow SugarChimp performance following a sugar upgrade and noticed that there are a lot of records for the same Contact in the SugarChimp table. Is that normal? Will the contact be synchronised once per sunc regardless of how many records there are, or will there be a sync operation for every individual record?
2 years ago
Happy to help. Yes, having records from the same contact in the SugarChimp table is normal as there may be different pieces of data being synced for that record. Can you tell me more about the slow SugarChimp performance you're experiencing?
Thanks, Heidi
2 years ago
Thanks. The health status page never quite gets completed ... there are always items pending to/from MC.
The schedular is running every 10mins, and is running as expected. Also the /#SugarChimp/layout/adminbatches page is fine ... there's the occasional error but generally ok.
One thing to note is that our target list has 84,117 Total Entries, and there's quite a lot of activity -- maybe 500 changes a day
2 years ago
i think what might be happening is that while the schedular is running there are changes that add items to the sugarchimp table and so as soon as the script finishes there are still more to sync, and so it never finishes
2 years ago
That amount of changes shouldn't be an issue at all. I'm wondering if there are old items in the queue that could be cleared out. There are a couple of things we can check:
Happy to also hop on a call together if you prefer to do some troubleshooting. If you'd like to do that, feel free to schedule one here: https://calendly.com/fanaticallabs_support/sugarchimp-support-meeting
Best, Heidi
2 years ago
Thanks for sharing those screenshots with me through mailchimp@fanaticallabs.com. I think we're now seeing data move as it should but please let me know if you have any further concerns.
Best, Heidi