This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: 

This topic contains 1 reply, has 2 voices.

Last updated by Diego Pereira 5 months, 1 week ago.

Assigned support staff: Diego Pereira.

Author Posts
May 8, 2019 at 2:13 pm #3767617

stefanG-37

Hi,

I recognized that I have a slow query on every post page of my blog and as it grabs informations from wpml tables I thought it might be an issue of your plugin. Here is the query which selects about 9000 lines of information on every single post...
SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy
FROM wordpress_icl_translations wpml_translations JOIN wordpress_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN wordpress_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id
Maybe you can think about a better way on getting the informations 🙂

Best regards, Stefan

May 8, 2019 at 7:05 pm #3770321

Diego Pereira
Supporter

Languages: English (English ) Spanish (Español ) Portuguese (Brazil) (Português )

Timezone: America/Sao_Paulo (GMT-03:00)

Hello @stefang-37, welcome to the WPML support Forum!

Please go to WPML → Support → Troubleshooting and click on "Recreate ST DB Cache tables", after that visit the pages of the website a few times to recreate the cache tables. The issue still occurs after that?

Here is some tips on how you can improve performance on some points:
- Check if your server meet the minimum WPML/WordPress requirements
WPML: https://wpml.org/home/minimum-requirements/
WordPress: https://wordpress.org/about/requirements/

Please take a look at this article to see how to optimize your website with WPML: https://wpml.org/2012/01/can-your-site-run-faster/

Please check auto-registered domains in WPML → String Translation and make sure that all domains are included.

Also, disable the following settings:
- Adjust IDs for multilingual functionality (WPML → Languages)
- Track where strings appear (WPML → String translation)

More details on this link: https://wpml.org/faq/prevent-performance-issues-with-wpml/

Please let me know if it worked for you.

All the best,
Diego