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+01:00)

本主题包含 0 則回覆，有 1 声音。

最后由 Jasmin 1 month, 1 week前更新。

协助者：： Lucas Vidal de Andrade.

作者	帖子
5 11 月, 2025 于 8: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?

作者

帖子

5 11 月, 2025 于 8: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?'已关闭，不接受新回复。