Home›Support›English Support›[Resolved] Is this normal WMPL usage to be taking so much tables on the database or something's wrong?
[Resolved] Is this normal WMPL usage to be taking so much tables on the database or something's wrong?
This thread is resolved. Here is a description of the problem and solution.
Problem: The client is experiencing issues with WPML taking up a large portion of the database and automatic translation updates occurring despite using manual translations. The client wants to prevent these automatic updates and reduce the database size. Solution: 1. To manage ongoing translation jobs, navigate to WPML > Translation Management > Jobs and cancel all ongoing and in-progress jobs. For any pages still showing an in-progress status, manually save or update them in the second language. 2. For issues related to database size, refer to the errata on reducing the size of WPML tables: https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/ 3. Advanced Custom Fields (ACF) field groups should be set as not translatable to avoid unnecessary translations: https://wpml.org/errata/advanced-custom-fields-field-group-should-be-set-as-not-translatable/
If this solution does not apply to your case, or if it seems outdated, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket at WPML support forum.
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Background of the issue:
I am trying to speed up the site under development. When cleaning the database, I noticed WPML is responsible for almost 50% of the whole database. I always translate by hand but sometimes I get a message that the translation is being updated and I get a gear icon on the translation for that page. I don't want that to happen as I only use manual translations. I already posted this question days ago and got no response, please help.
Symptoms:
WPML is taking up a large portion of the database, and automatic translation updates are occurring despite using manual translations.
Questions:
Is it normal for WPML to take up so much space in the database?
How can I prevent automatic translation updates and use only manual translations?
Is there a way to have a more lightweight site with WPML?
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
Hello,
Yes, it is expected that WPML runs a lot of database queries and the more content and translation you will have, the bigger will be WPML's custom tables.
The translation status will always change once the original content has been edited or a translation has been completed - this is expected and there is not way to disable this behavior. Its purpose is for you and WPML to know which contents need a translation.
To avoid automatic translation, make sure that on your original content, inside the right sidebar of the WordPress Editor, the translation method is set to "WordPress Editor".
Once you switch this translation method a dialog will allow you to apply the same setting to the whole website.
Yes, you can see that I have pages and pages of posts and translations that say they need to be updated but I already did, so I think that this is causing a lot of trouble. If I disable that what you described will all that go away? O do I need to take more steps so as to clear up eveerythig?
I would appreciate some help on having this cleaned up
Let me first try to clear things up here, issue you originally reported with large DB tables and translation status are not directly related, and those are 2 different topics.
If you are using what my colleague suggested and switched to the WP editor, you will continue to use the manual method for translation. Once you do that, go to WPML > Translation Managment > Jobs and cancel all ongoing and in-progress jobs.
Then there could still be some pages left in in-progress state that would require you to go to 2nd language page and save / update, so this status changes.
Ok... i'll open a separate topic for the ACF, let's focus on the large database and how to get a slimmer lightweight site when using WPML.
What you suggest of using WP EDITOR is not a good solution, because that unlinks the pages/posts so if I change a category or something I'd have to get in the translation and update it too, whereas if linked that sort of editing is not necessary.
I also have all my posts using the DUPLICATE function because the posts are not translated they display in english in both languages so no need for that.
So lets focus on the main issue which is: I always translate by hand using WPML translation where I just replace text on the provided fields, but sometimes I get a message that the translation is being updated and I get a gear icon on the translation for that page. I don't want that to happen as I only use instant translations made by me on the moment, no need for them to go on queue. I already posted this question days ago and got no response, please help.
So WPML is taking up a large portion of the database, and automatic translation updates are occurring despite using manual translations.
Is it normal for WPML to take up so much space in the database?
How can I prevent automatic translation updates and use only manual translations via WPML editor?
Is there a way to have a more lightweight site with WPML?
1) What you get gear icon and status needs update, is expected and there is no way around it. It will happen each time you update default language page. Also note you can not have enabled WPML editor and use manual transzltion / manually editing 2nd language, you can not mix translation methods as this will cause issues. If you are doing it manually by editing 2nd language you need to switch to WP editor.
2) For automatic translation, do you mean they happen when you open WPML editor or? If yes, inside ATE WPML editor there is cog settings icon and you can choose to not automatically translate when you open editor.
3) As for DB size, this already escalated and we are working on improving their size, in the meantime you can try to follow next errata and see if that helps:
when I say MANUALLY I don't mean the WP EDITOR, I mean that I use the CLASSIC WPML EDITOR but I don't make use of the online translation service, I just input my self the translations in each field the CLASSIC WPML EDITOR gives me when I click the PENCIL to edit the translation.
The GEAR icon should NOT appear, as I just edited the translation and clicked SAVE AND CLOSE, so why does it needs update? I think it's a bug, something is telling me to update a thing I just updated.
This is not a duplicate ticket, what you point me to is about the pop up, this was all the time about the DB SIZE and this BUG that keeps creating jobs and updates registries on the DB although I just updated the translation, and with enough time, it creates an impossible big Database
Hope this clarifies it
New threads created by Dražen and linked to this one are listed below:
Okay, thanks for getting back and clarifying the case.
I will open a new ticket for you report, and lest start there clear on topic with gear icon issue, since seems this ticket went in different conversation, and it will just cause confusion for future readers.
