#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?
9 months 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
9 months 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
9 months 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
9 months 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
9 months 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