-
Notifications
You must be signed in to change notification settings - Fork 110
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Clean table mailchimp_sync_ecommerce #1913
Comments
Hi @webloft no, you can't remove register from this table. Best |
@gonzaloebiz but the question is: do we really need this status? Our understanding is that the information is somehow temporarly since it's required to set up a task to sync of course but has no other effect if this data is already processed. Yes, the status is somehow useful in the backend but not required for mailchimp servers on the remote side. And this issue shouldn't be closed since the the query is used in the Adminhtml controller and generates a server timeout by opening the configuration page. |
Comment this line
But you can delete the registers on this table |
OK, thanks. Sorry, to ask again but
I think we could remove data that has multiple entries? for example product data that was synched yesterday but also today (so we don't need the older entry?) Big tables are also an issue for Cron Jobs and resource usage of the database server. |
In this table you have only one entry by object (products, orders, etc) by mailchimp store, if you sync one product today and sync the same product tomorrow, only one register exists for this product. Best |
We have measured that the query
triggered by backend actions causes a waiting time of 10min(!)
In fact, the table is very big:
mailchimp_sync_ecommerce
There seems no routine which cleans up this table. (Do we need all that old data?)
Additional:
Which data can be removed manually? We would like to remove data from last year, is this save?
The text was updated successfully, but these errors were encountered: