Menu sync time out issue - workaround or Patch?

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	-
-	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	-

Часовой пояс службы поддержки: Europe/Vienna (GMT+02:00)

Эта тема содержит 0 ответ, имеет 1 голос.

Последнее обновление: Jasmin 5 месяцев, 1 неделя назад.

При содействии: Lucas Vidal de Andrade.

Автор	Сообщения
05.11.2025 в 08:02 #17548401
Jasmin	Background of the issue: We have a problem updating the site using WPML, either modifications or translation itself, as well as Menu sync. We hired a developer who found that the WPML menu sync feature is resource-intensive, causing Cloudflare to time out. The developer attempted several optimizations, including clearing the PYS events queue table, installing the WP-Optimize plugin, and logging database queries. They also tried running menu sync via CLI and considered caching options like Kinsta's Redis cache. The issue seems to be related to the n+1 query problem due to the high number of menu options and languages. Symptoms: Menu sync feature in WPML is causing Cloudflare to time out due to high resource usage and a large number of database queries. Questions: Can WPML authors suggest a workaround or patch to make the menu sync feature less resource-intensive? Is there a way to solve the n+1 query problem in WPML's menu sync feature? Can WPML stream output to prevent Cloudflare from timing out?

Автор

Сообщения

05.11.2025 в 08:02 #17548401

Jasmin

Background of the issue:
We have a problem updating the site using WPML, either modifications or translation itself, as well as Menu sync. We hired a developer who found that the WPML menu sync feature is resource-intensive, causing Cloudflare to time out. The developer attempted several optimizations, including clearing the PYS events queue table, installing the WP-Optimize plugin, and logging database queries. They also tried running menu sync via CLI and considered caching options like Kinsta's Redis cache. The issue seems to be related to the n+1 query problem due to the high number of menu options and languages.

Symptoms:
Menu sync feature in WPML is causing Cloudflare to time out due to high resource usage and a large number of database queries.

Questions:
Can WPML authors suggest a workaround or patch to make the menu sync feature less resource-intensive?
Is there a way to solve the n+1 query problem in WPML's menu sync feature?
Can WPML stream output to prevent Cloudflare from timing out?

Тема '[Закрытые] Menu sync time out issue — workaround or Patch?' закрыта для новых ответов.