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.

This thread is resolved. Here is a description of the problem and solution.

Problem: The user would like to cleanup WordPress tables from revisions to gain performances and asks if it will be ok with WPML. Solution: WPML offers it own cleanup tools in WPML->Support->Troubleshooting->Cleanup You can also be safely delete the revisions from WPML perspective. Here some plugins and articles that might be interesting for you: => http://wordpress.org/plugins/better-delete-revision/ => http://wordpress.org/plugins/rvg-optimize-database/ => https://wordpress.org/plugins/delete-post-revisions-by-tricks-panda/

Regarding WPML performance, here are articles that might help: => http://wpml.org/2012/01/can-your-site-run-faster/ => http://wpml.org/faq/why-string-translation-appears-to-slow-down-sites/ => http://wpml.org/faq/how-to-optimize-mysql-queries/ => http://wpml.org/2011/03/wpml-with-w3tc/

Tagged: 

This topic contains 2 replies, has 2 voices.

Last updated by Jamal 4 months, 1 week ago.

Assigned support staff: Jamal.

Author Posts
June 12, 2019 at 9:04 am #4002181

chuan-koonK

Tell us what you are trying to do?
We are cleaning our database. Our Post/Page Revisions ballooned to 12K. Is it safe to Delete all of these?
Is there any documentation that you are following?
No
Is there a similar example that we can see?
No
What is the link to your site?
hidden link

June 12, 2019 at 9:31 am #4002549

Jamal
Supporter

Languages: English (English ) French (Français )

Timezone: Africa/Casablanca (GMT+01:00)

Hello,

Thank you for contacting WPML Support. I will be glad to help with this.

I could not find a previous case like this to better advise you. I am approaching our second tier supporters for advice.

What I would do, is to try it on a staging site, I'll run then the cleanup routines in WPML->Support->Troubleshooting->Cleanup.

In the meanwhile, please paste your WPML Debug information in the Debug information field?
- http://wpml.org/faq/provide-debug-information-faster-support/

Best regards,
Jamal
WPML Support

June 12, 2019 at 9:55 am #4002727

Jamal
Supporter

Languages: English (English ) French (Français )

Timezone: Africa/Casablanca (GMT+01:00)

Hello,

We think that it would be safe to delete the revisions from WPML perspective. Here some plugins and articles that might be interesting for you:
=> http://wordpress.org/plugins/better-delete-revision/
=> http://wordpress.org/plugins/rvg-optimize-database/
=> https://wordpress.org/plugins/delete-post-revisions-by-tricks-panda/

Regarding WPML performance, here are articles that might help:
=> http://wpml.org/2012/01/can-your-site-run-faster/
=> http://wpml.org/faq/why-string-translation-appears-to-slow-down-sites/
=> http://wpml.org/faq/how-to-optimize-mysql-queries/
=> http://wpml.org/2011/03/wpml-with-w3tc/

Best regards,
Jamal