Performance

Problema:
Estás intentando activar WPML y levantar el mantenimiento de tu página web, pero la base de datos se desborda por la cantidad de consultas realizadas. Un ejemplo de consulta problemática es:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND wp_posts.ID NOT IN (415399,415399) AND ( wp_term_relationships.term_taxonomy_id IN (3) ) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'es' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','tdb_templates','mc4wp-form' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','tdb_templates','mc4wp-form' ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6;

Solución:
Te recomendamos incrementar el límite de memoria de WordPress a un mínimo de 128MB. Puedes hacerlo añadiendo el siguiente código en tu archivo wp-config.php, justo encima de la línea /* That's all, stop editing! Happy blogging. */:

/* Memory Limit */<br />define('WP_MEMORY_LIMIT', '128M');

Después de aumentar el límite de memoria, verifica si el problema persiste accediendo a WPML -> Soporte.

Si esta solución no resuelve el problema o si parece desactualizada, te recomendamos abrir un nuevo ticket de soporte. También es aconsejable revisar los problemas conocidos y confirmar que tienes instaladas las últimas versiones de los temas y plugins. Para más ayuda, visita nuestro foro de soporte.

Problem:
The client installed WPML on their website and experienced significant performance issues. The site became slow and unresponsive, and disabling WPML restored normal performance. The issues persisted despite updating plugins and themes, and the WooCommerce Force Default Variant plugin and the theme Savoy were suspected to be contributing to the problem.
Solution:
We recommended the client to update all outdated functionalities and provided a checklist to enhance site performance, available at https://wpml.org/forums/topic/how-can-i-improve-performance-of-a-slow-site/#post-15350474. We escalated the issue to our 2nd tier support for deeper analysis. It was found that the WooCommerce Force Default Variant plugin and the nm_template_loop_attributes function in the Savoy theme were causing the issues. We advised against using the WooCommerce Force Default Variant plugin and recommended upgrading WPML plugins to the latest version for performance improvements.

If this solution does not resolve your issue or seems outdated, please check related known issues at https://wpml.org/known-issues/, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. If problems persist, we highly recommend opening a new support ticket at WPML support forum.

Problem:
You are experiencing a performance issue with WPML where a GET query to check if the REST API is available is causing the Admin Panel to load very slowly. Despite increasing the WP memory limit to 512M, the issue persists.

Solution:
First, ensure that your WordPress memory limit meets the minimum requirements by adding the following code to your wp-config.php file:

/* Memory Limit */<br />define('WP_MEMORY_LIMIT', '512M');

You can verify the memory limit in WPML -> Support. If the performance issue continues, follow these steps:
1. Create a full site backup or a staging site.
2. Update any outdated plugins and themes.
3. Flush any existing cache.
4. Deactivate all plugins, including WPML ones, and activate a default WordPress theme like Twenty Twenty.
5. Reactivate the WPML plugins. If the issue resolves, reactivate your theme and other plugins one by one to identify the problematic one.

Regarding your specific questions:
1. Temporarily disabling the REST API check using

add_filter('wpml_health_check_enabled', '__return_false');

can cause unintended issues with WPML functionality.
2. The long duration of the GET request is not due to WPML’s external server response time.
3. There is no way to cache or optimize this request within the WPML interface.

If these steps do not resolve your issue or if the solution becomes outdated, we recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If necessary, please open a new support ticket at WPML support forum for further assistance.

Problem:
You are experiencing very slow performance on your website, both on the frontend and in the WP-admin area, after publishing it. The performance issue is particularly severe in the WP-admin area.

Solution:
We recommend that you first address the optimization of WPML tables. This involves adding indexes and a primary key to improve database efficiency. For detailed guidance on how to do this, please refer to our documentation on WPML tables.

Please also consult with this check list.

Once you have made these adjustments, if the problem persists, it might be due to other factors that are not covered by this solution or might be outdated. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins.

If these steps do not resolve the issue, please do not hesitate to open a new support ticket. You can reach us directly for further assistance at WPML support forum.