Background of the issue:
I regularly create a staging site for various developmental purposes. After updating to the new version of the WPML main plugin, something went wrong. It seems like too many things were translated, resulting in a big invoice by surprise.
Symptoms:
The creation of a staging site now takes hours, whereas it used to take 15 minutes.
Questions:
Why does creating a staging site take significantly longer after updating WPML?
What can I do to remove unnecessary translations, especially backend strings that are not needed?
Also, how can I clean up or reduce the size of the large translation tables?
Thanks. For now, no need for MySQL credentials, I'll use Duplicator Pro to create a dump.
We'll see if there is something that cause the db to grow so much and if we can reduce the table size.
As for optimization, it's something that need to be adjusted on a site by site case. Let's see if we can improve the performance checking the icl_ tables and if you still have issues later we'll tackle them.
