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

Last updated by Bruno Kos 3 months ago.

Assigned support staff: Bruno Kos.

Author Posts
July 15, 2019 at 12:24 pm #4210917

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

July 15, 2019 at 3:53 pm #4213119

Andreas W.
Supporter

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

Timezone: America/Lima (GMT-05:00)

Hello,

Thank you for contacting the WPML Support Forum.

Please test your site with Google Chrome and install the following add-on which will indicate the page generation time and more information in the top admin bar.

hidden link

In case you will still experience a unexpected page generation time and warnings in regards to duplicated or slow querries that are based on WPML Plugins, we would kindly like to ask you to provide a new Duplicator package.

The package we received seems to seperate the site content and the database and we can not migrate the site in this manner.

https://wordpress.org/plugins/duplicator/

Duplicator is free of use for backups up to 500MB and the package includes any content, themes, plugins and the database. As your site seems to exceed this limit there is a workaround.

In the first step of the Duplicator package creation process you are able to set filters for folders that will be excluded from the package building process.

You can simply add the filters for cache and uploads and it should bring your backup package to a minimal size.

More information here:
hidden link

In case of any issues please let me know. I can offer to create a package with Duplicator PRO in case you provide access to the site.

I have enabled the private box for your next reply. Please also add here a list of your plugins and theme for our developers who will revise your site and apply fixes into the upcoming version of CMS Multilingual and String Translation.

Kind regards
Andreas

July 17, 2019 at 7:00 pm #4233047

Andreas W.
Supporter

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

Timezone: America/Lima (GMT-05:00)

Hello,

Thank you for the provided information.

Your site´s copy has been escalated to our developers in order to investigate and implement necessary changes into the next update for WPML 4.2.8.

Further, I am assigning this ticket to an agent of our performance team for further testing. We will be in contact soon.

Kind regards
Andreas

July 18, 2019 at 7:39 am #4235753

Bruno Kos
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

Thank you for contacting WPML support!

I'm currently working with our developers on performance issues. I have installed this chrome addon:
hidden link

And it usually shows something like 3.x. seconds. It is also worth noting that SQL queries are just a part of overall site load.

While testing I have temporarily enabled this option:
WPML -> Theme- und Plugin-Lokalisierung -> String Translation nicht zum Übersetzen von Themes und Plugins verwenden

Can you test yourself like this?

Because in the next versions of WPML and string translation, this will be enabled by default and they should also bring some other performance gains we are currently heavily testing.

Regards,
Bruno Kos

July 18, 2019 at 8:18 am #4235959

ivanaT

Hi,
I installed the add-on and sometimes it loads 3.x., and sometimes 5.x. seconds.

Also, I enabled this option:
WPML -> Theme- und Plugin-Lokalisierung -> String Translation nicht zum Übersetzen von Themes und Plugins verwenden
I can not see any problem when this is enabled. Should I leave that field enabled?

When I run the Query Monitor on the website there is a loading time between 2-3 seconds, and sometimes I am getting errors like:
1. Certificate verification disabled (sslverify=false)
hidden link
?doing_wp_cron=1563436771.0182719230651855468750

2. Constant SAVEQUERIES already defined - Error

Other critical things are:
1. PHP verson on the server is not upgraded

2. DB version also out of date

3. The optional module imagick is not installed or has been disabled.

My client is pressing me to come up with solution for speeding up the website, and I would just like to know does any of these errors have anything to do with WPML pugin, because the hosting company is blaming WPML plugin for all performance problems.
I am using this plugin on multiple other websites and I didn't had any problems until now.

Thanks!
Ivana

July 18, 2019 at 10:23 am #4237451

Bruno Kos
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

1. Certificate verification disabled (sslverify=false)
hidden link
?doing_wp_cron=1563436771.0182719230651855468750

2. Constant SAVEQUERIES already defined - Error

Other critical things are:
1. PHP verson on the server is not upgraded

2. DB version also out of date

3. The optional module imagick is not installed or has been disabled.

These are not related to WPML, I don't see the connection.

As for the speed, WPML does add some loading due to complexity of the plugin and various services and options it offers. If you try disabling WPML, what are the loading times then?

Regards,
Bruno Kos

July 18, 2019 at 1:24 pm #4239063

ivanaT

Hi,
If I disable the plugin or enable it the difference is around 1 second. Is that normal?

Thanks for your help.

July 18, 2019 at 2:08 pm #4239529

Bruno Kos
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

Since the overall loading is always between 3-5 seconds, having 1 second from WPML impact would be somewhere on average (since it is a complex plugin and brings a lots of features on the table) and I doubt we would be able to get more speed from that.

There are some things your client could try:

- Lower the weight of the page size in MB. Compress images (EWWW plugin), minimize their quantity.
- Try to check your site with faster internet connection.
- Deactivate all unneded plugins. Do not use monitoring plugins like a Query Monitor on production site.
- Try to implement object caching with Redis. This significantly improves performance on backend. It requires support on hosting or VPS and a plugin. Better use this one: https://wordpress.org/plugins/redis-cache/ Some page caching plugins like a W3 Total Cache can provide object caching too. In this case, Redis Cache plugin is not needed.
- Try to use faster hosting or VPS server. Heavy sites require more resources.
- Try to use page cachning plugin like Super Cache, W3 Total Cache, or WP-Rocket.
- Do not use any kind of SSL-helping plugins. They produce significant overhead redicrecting every request. To use https properly, just convert all links in the database by Duplicator plugin or WP-CLI.

Regards,
Bruno Kos

July 18, 2019 at 2:50 pm #4239777

ivanaT

Thanks for your help.

July 19, 2019 at 5:12 am #4244023

Bruno Kos
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hi,

Ok, let me know if there's anything else I can assist with. Otherwise I believe we can mark this thread as resolved, if otherwise, you can reopen within the next 12 hours.

Regards,
Bruno Kos