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: link oculto.
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?
O tópico “[Fechado] Huge Number of WPML Duplicate Queries” está fechado para novas respostas.
