Huge Number of WPML Duplicate Queries

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 18:00	9:00 – 18:00	9:00 – 18:00	9:00 – 18:00	9:00 – 18:00	-
-	-	-	-	-	-	-

Fuseau horaire du support : Asia/Karachi (GMT+05:00)

Ce sujet contient 0 réponse, a 1 voix.

Dernière mise à jour par andreaT-10 Il y a 4 mois et 1 semaine.

Assisté par: Waqas Bin Hasan.

Auteur	Messages
Avril 4, 2025 à 10:55 am #16897031
andreaT-10	Background of the issue: I am trying to solve a CPU consumption problem caused by hundreds of duplicate queries generated by WPML, in particular by the functions WPML_Term_Query_Filter->guess_term() and get_terms() on taxonomies like pa_colore and pa_misura. I use WooCommerce + WPML Multilingual CMS + WooCommerce Multilingual. The site is translated into two languages (Italian and English) and I cannot disable WPML. On the homepage and on the product category page, hundreds of duplicate queries are loaded, about 500. My hosting (SiteGround) does not support Redis and Memcache degrades performance. I cannot use persistent object cache. Link to the problem: lien caché. Symptoms: Critical CPU consumption issue due to hundreds of duplicate queries generated by WPML, especially by the WPML_Term_Query_Filter->guess_term() and get_terms() functions. Memcache degrades performance from 192 duplicate queries to over 900. Questions: Is there a way to reduce duplicate queries generated by guess_term() and get_terms()? Is it possible to implement an internal WPML caching for these results, also on the file system or transient DB side? Do you have a specific solution in your roadmap for those who cannot use Redis or Memcache?

Auteur

Messages

Avril 4, 2025 à 10:55 am #16897031

andreaT-10

Background of the issue:
I am trying to solve a CPU consumption problem caused by hundreds of duplicate queries generated by WPML, in particular by the functions WPML_Term_Query_Filter->guess_term() and get_terms() on taxonomies like pa_colore and pa_misura. I use WooCommerce + WPML Multilingual CMS + WooCommerce Multilingual. The site is translated into two languages (Italian and English) and I cannot disable WPML. On the homepage and on the product category page, hundreds of duplicate queries are loaded, about 500. My hosting (SiteGround) does not support Redis and Memcache degrades performance. I cannot use persistent object cache. Link to the problem: lien caché.

Symptoms:
Critical CPU consumption issue due to hundreds of duplicate queries generated by WPML, especially by the WPML_Term_Query_Filter->guess_term() and get_terms() functions. Memcache degrades performance from 192 duplicate queries to over 900.

Questions:
Is there a way to reduce duplicate queries generated by guess_term() and get_terms()?
Is it possible to implement an internal WPML caching for these results, also on the file system or transient DB side?
Do you have a specific solution in your roadmap for those who cannot use Redis or Memcache?

16897031-Screenshot 2025-04-04 125354.jpg

Le sujet « [Fermé] Huge Number of WPML Duplicate Queries » est fermé aux nouvelles réponses.