Problem: You are experiencing a high database load on your site due to SQL queries that seem to be related to the WPML plugin. The queries in question are complex and involve multiple joins and conditions. Solution: Upon investigation by our compatibility developers, it was determined that the problematic SQL query originates from the 'Easy Real Estates' plugin, not WPML. This query is responsible for calling post attachments such as Thumbnail IDs. To verify this, we modified the query by removing WPML-related entries, which resulted in the query still running with a significant load, indicating that the issue lies within the 'Easy Real Estates' plugin itself. If this solution does not apply to your case, or if it becomes outdated, we recommend opening a new support ticket. Additionally, 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. For further assistance, please visit our support forum at WPML Support Forum.
The client is developing a site and needs translations only on the frontend. They are looking to improve site speed by deleting unnecessary backend translation strings in WPML.
Solution:
If you're experiencing similar issues, we recommend following these steps to delete unnecessary strings to potentially improve your site's speed:
1. Ensure you have a full site backup before making changes. 2. Navigate to WPML → String Translation. 3. Scroll down to the 'Remove strings by domain' section. 4. Click 'Remove strings'. 5. Select the domains you want to delete and click 'Remove'.
This process will remove all untranslated strings in the selected domains, and they will no longer appear on the String Translation screen.
Please note that this solution might be outdated or not applicable to your specific case. 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 the issue persists, please open a new support ticket at https://wpml.org/forums/forum/english-support/.
Problema: El cliente está intentando optimizar la base de datos debido a su elevado tamaño, originado de una instalación anterior. Se observa un tamaño considerable en varias tablas de WPML como wp_icl_strings (19,6MB), wp_icl_string_translations (11,5MB), y wp_icl_translation_status (3,6MB). El cliente desea saber si es posible optimizar estas tablas y por qué las opciones de optimización en 'Soporte-> Solucionador de problemas' no han tenido impacto. Solución: Las tablas mencionadas almacenan información de cadenas traducidas y generalmente no deberían afectar el rendimiento del sitio. Para optimizar estas tablas, recomendamos utilizar la opción de troubleshooting disponible en WPML -> Soporte -> Enlace 'solución de problemas' -> Botón 'Cleanup and optimize string tables': https://wpml.org/documentation/support/wpml-troubleshooting-options/ Es crucial realizar una copia de seguridad de la base de datos antes de ejecutar esta o cualquier otra opción de troubleshooting. Además, sugerimos contactar a los proveedores de hosting para que incrementen la versión de PHP a la v8.0 o v8.1, que son más rápidas.
Si esta solución no es relevante debido a que podría estar desactualizada o no aplicar en su caso, le recomendamos abrir un nuevo ticket de soporte. También es altamente recomendable revisar los problemas conocidos en https://wpml.org/known-issues/, verificar la versión del arreglo permanente y confirmar que tiene instaladas las últimas versiones de temas y plugins.
