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 2 replies, has 2 voices.

Last updated by ivanaT 3 months ago.

Assigned support staff: Carlos Rojas.

Author Posts
July 2, 2019 at 1:23 pm #4127351

ivanaT

Hello,

I’m having performance issues with WPML. As soon as the WPML plugin is enabled on our website, drastic delays are starting, and the loading of a website is longer for multiple seconds. We’ve tried clearing all sorts of caches and playing arround with the all available settings, but nothing changed. Disabling WPML makes the website become fast again.

We have the following plugins installed:
Breadcrumb NavXT, Contact Form 7, Contact Form 7 Multilingual, DHL for WooCommerce, GiroCheckout, Go Pricing – WordPress Responsive Pricing Tables, Meta Box, Query Monitor, Redux Framework, Swift Framework, WooCommerce, WooCommerce Blocke, WooCommerce Deutsche Post Internetmarke, WooCommerce multilingual, WooCommerce PayPal Checkout Gateway, WooCommerce Quickview, WooCommerce Services, WPForms Lite, WPML Multilingual CMS, WPML String Translation, WPML Translation management, YITH WooCommerce Wunschliste.

Disabling any of them doesn’t actually do anything, to my knowledge.
Is there a way to debug this and find out what is causing the slowdown?

Thanks,
Ivana

July 2, 2019 at 4:48 pm #4128917

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

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

Hello,
Thank you for contacting WPML support.

I kindly ask you to visit this links where you will find the steps to follow in order to prevent and debug performance issue related to WPML:
- https://wpml.org/faq/prevent-performance-issues-with-wpml/
- https://wpml.org/faq/how-to-debug-performance-problems/

Kind regards,
Carlos

July 15, 2019 at 8:41 am #4208385

ivanaT

Hi!
I installed the W3 Total Cache Plugin and it is working really good, but the website is still slow. It takes 5 seconds for the page to start loading, and when I disable WPML it is about 3 seconds.

I got this from the guys who are hosting this website.
We've extracted the slow queries used by WPML:
Time: 45.4ms (0.045444011688232s)
Query:
SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_7trn3q_icl_strings s LEFT JOIN wp_7trn3q_icl_string_translations st ON s.id=st.string_id AND st.language='de' AND s.language!='de' WHERE s.context = 'default' LIMIT 1000 OFFSET 6000
Function: WPML_DB_Chunk->retrieve()

Time: 21.5ms (0.021491050720215s)
Query:
SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_7trn3q_icl_strings s LEFT JOIN wp_7trn3q_icl_string_translations st ON s.id=st.string_id AND st.language='de' AND s.language!='de' WHERE s.context = 'default' LIMIT 1000 OFFSET 4000
Function: WPML_DB_Chunk->retrieve()

Time: 13.3ms (0.013292074203491s)
Query:
SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_7trn3q_icl_strings s LEFT JOIN wp_7trn3q_icl_string_translations st ON s.id=st.string_id AND st.language='de' AND s.language!='de' WHERE s.context = 'default' LIMIT 1000 OFFSET 2000
Function: WPML_DB_Chunk->retrieve()

Time: 7.4ms (0.007361888885498s)
Query:
SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_7trn3q_icl_strings s LEFT JOIN wp_7trn3q_icl_string_translations st ON s.id=st.string_id AND st.language='de' AND s.language!='de' WHERE s.context = 'default' LIMIT 1000 OFFSET 0
Function: WPML_DB_Chunk->retrieve()

Time: 27.1ms (0.027081966400146s)
Query:
SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_7trn3q_icl_strings s LEFT JOIN wp_7trn3q_icl_string_translations st ON s.id=st.string_id AND st.language='de' AND s.language!='de' WHERE s.context = 'WordPress' LIMIT 1000 OFFSET 0
Function: WPML_DB_Chunk->retrieve()

Time: 10.6ms (0.0105881690979s)
Query:
SELECT COUNT(id) FROM wp_7trn3q_icl_strings WHERE context = 'WordPress'
Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()

Time: 11.0ms (0.011005878448486s)
Query:
SELECT COUNT(id) FROM wp_7trn3q_icl_strings WHERE context = 'default'
Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()

Time: 1.9ms (0.0018661022186279s)
Query:
SELECT post_status, COUNT( * ) AS num_posts FROM wp_7trn3q_posts WHERE post_type = 'product' GROUP BY post_status
Function: wp_count_posts()

Time: 0.9ms (0.00091409683227539s)
Query:
SELECT term_id, meta_key, meta_value FROM wp_7trn3q_termmeta WHERE term_id IN (137,124,114,115,126,29,110,125,103,127,104,129,94,141,30,96,100,113,119,131,2652,117,2653,102,99,108,130,111,168,109,128,120,95,144,909,150,33,112,169,139,105,134,98,151,148,97,122,145,146,31,32,147,140,136,101,116,118,133,149,2646,2648,138,106,135,123,107,121,132,23,142,143) ORDER BY meta_id ASC
Function: update_meta_cache()

Time: 1.8ms (0.0017740726470947s)
Query:
UPDATE `wp_7trn3q_options` SET `option_value` = '1563168758' WHERE `option_name` = '_transient_timeout_atelier_typekit_kits'
Function: update_option()

- I am not sure what is the problem, but I saw that there is a slow server response time too. Can you please check that website again and if you need the website access I will send it to you. You have my speed tests screenshots in attachment.

Thanks for your help.
Ivana