Tell us what you are trying to do? Duplicate, delete, edit and add new woocommerce products.
Now that I translated all my 3500 products into the third language (german), I started experiencing huge lag spikes (up to a full minute) when managing my woocommerce products. Interesting as frontend performace has not suffered much.
I went to my hosting and the database has grown from 700MB to over 3.5GB, most of which being generic post_meta.
Has something gone very wrong? Is this a common problem? Is there anything I can do? Turning WPML off solves the problem, but then all my products appear duplicated in all 3 languages.
I have already provided access info in the previous ticket. As this is a performance issue, providing a staging site on a subdomain is not helpful because from my experience the performance there is generally worse, lacks SSL, etc. Feel free to switch WPML on and off.
Database size growing as you add/translate posts is normal as when you translate contents translated posts and its meta fields need to be stored as well.
I see you are using WPML 4.6.4, we now have WPML 4.6.5 which solves many issues can you please update WPML to it's latest version and see if it makes any difference?
Also, please follow the following tutorial on using Qurty Monitor to analyze performance issues on a site and see if it helps you find the issue and if it points to WPML, and if yes to what code/query exactly.
Furthermore, also check if adding indexes to the database as explained in the workaround of the following erratum ( although the erratum might not be related exactly ) helps, this might help sometimes in case the database is too large for the server to process.
