Skip Navigation

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.

Sun Mon Tue Wed Thu Fri Sat
- 12:00 – 14:00 12:00 – 14:00 12:00 – 14:00 12:00 – 14:00 12:00 – 14:00 -
- 17:00 – 21:00 17:00 – 21:00 17:00 – 21:00 17:00 – 21:00 17:00 – 21:00 -

Supporter timezone: Europe/Vienna (GMT+01:00)

This topic contains 69 replies, has 4 voices.

Last updated by Bigul 9 months ago.

Assisted by: Bigul.

Author Posts
September 28, 2023 at 8:03 pm #14484373

louisN-4

any news/updates?

September 29, 2023 at 12:45 pm #14487725

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

We have an update from our developers. The slow queries you have mentioned and the following slow queries showing in Query Monitor will be resolved in WPML 4.7. It is in the QA stage now and is expected to be released in a month. So kindly wait for the fix.

SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy
FROM lsk_icl_translations wpml_translations JOIN lsk_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN lsk_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id	

SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM lsk_icl_translate_job as jobs
INNER JOIN lsk_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN lsk_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN lsk_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN lsk_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM lsk_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (1,2,40)
OR 1=0 )
AND translations.language_code IN ('nl','en','de','he','ru')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )	

SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM lsk_icl_translate_job as jobs
INNER JOIN lsk_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN lsk_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN lsk_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN lsk_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM lsk_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (30)
OR translation_status.review_status IN ( 'NEEDS_REVIEW','EDITING' ) )
AND translations.language_code IN ('nl','en','de','he','ru')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )

Also, there are some improvements after we sync the translation jobs in our ATE server. Please check it on the staging site now and let us know your feedback.

--
Thanks!

Bigul

October 1, 2023 at 7:11 pm #14493779

louisN-4

we confirm their is an improvement in speed

shall we copy the plugin, or just wait for you to release the update to everyone?

October 2, 2023 at 4:21 am #14494055

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Thank you for the updates. Please upgrade to the latest version of WPML(4.6.6) on your live site after a full site backup{mandatory}. Because it also included some performance improvements.

We will get back to you soon when we have an update from our developers about the WPML 4.7 releases. Please wait.

--
Thanks!

Bigul

October 2, 2023 at 5:23 am #14494213

louisN-4

can we just wait for 4.7 and then upgrade to it?

October 3, 2023 at 8:49 am #14502553

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Thank you for the updates. That is also fine. You can try WPML 4.7 RC in the staging when it is ready.

We will ping you when we have an update from our developers about the WPML 4.7 releases. Please wait.

--
Thanks!

Bigul

October 3, 2023 at 12:40 pm #14504771

louisN-4

ok also give me zip, so i can deploy on production in case staging works

October 3, 2023 at 4:50 pm #14507499

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Thank you for the updates. Do you mean the WPML 4.7 version files or the 4.6.6 version currently used on the staging site?

You can download the WPML 4.6.6 version from https://wpml.org/account/downloads/

--
Thanks!

Bigul

October 3, 2023 at 4:54 pm #14507599

louisN-4

i am not enthusiastic to upgrade to 4.6.6 because of this
https://wpml.org/forums/topic/options-autoload-slow-ttfb/page/3/#post-14463037

so i prefer to go from 4.6.4 that we have on production to 4.7 directly

October 3, 2023 at 5:21 pm #14507941

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Thank you for the updates. WPML 4.7 is currently in the QA stage. We will ping you soon when we have an update from our developers about the WPML 4.7 releases. Please wait.

--
Thanks!

Bigul

October 4, 2023 at 11:22 am #14512257

louisN-4

we still have this code implemented
https://wpml.org/forums/topic/index-mysql-tables/page/3/#post-10883283

shall we remove it before we upgrade to 4.7?

October 4, 2023 at 4:56 pm #14515033

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

Thank you for the updates. As per our internal tickets, that issue is already resolved and patched in the latest versions of WPML. So our suggestion is please wait for the WPML 4.7 beta release. So you can test with the beta version on your staging site before the final release.

--
Thanks!

Bigul

October 8, 2023 at 9:16 pm #14535433

louisN-4

good week bigul,

any update when 4.7 be released?

October 9, 2023 at 5:06 pm #14541889

Bigul
Supporter

Languages: English (English )

Timezone: Europe/Vienna (GMT+01:00)

Hello,

As of now, we don't have an exact date for the release of WPML 4.7. It is still in the QA stage. Please wait.

--
Thanks!

Bigul

October 9, 2023 at 10:28 pm #14543001

louisN-4

we are bleeding money because of your software component failure, i need to know when you will release this fix

or alternativly, give me the fixed query