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

Last updated by Itamar 3 months ago.

Assigned support staff: Itamar.

Author Posts
June 15, 2019 at 2:22 pm #4027751

winnieV

Hi

Since I've installed WPML the site has slowed down a lot.

Using Clearfy I get approxiamtely the following results in loadtimes (factor 3x to 4x):
- Homepage (including Ads & images, not optimized) - 2,5s-3,0s with WPML, 060-0,80 without WPML
- Blog post - similar results
- General terms page (no ads & images, not optimized) - 1,8s-2,3s with WPML, 0,40s-0,70s without WPML

I've already performed all the considerations in this tutorial: https://wpml.org/faq/prevent-performance-issues-with-wpml/ and more.

Using Query Monitor the following queries are slow:
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 MXf2b0_icl_strings s
LEFT JOIN MXf2b0_icl_string_translations st
ON s.id=st.string_id
AND st.language='nl-be'
AND s.language!='nl-be'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 5000

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 MXf2b0_icl_strings s
LEFT JOIN MXf2b0_icl_string_translations st
ON s.id=st.string_id
AND st.language='nl-be'
AND s.language!='nl-be'
WHERE s.context = 'default'
LIMIT 1000 OFFSET 6000

SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy
FROM MXf2b0_icl_translations wpml_translations JOIN MXf2b0_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN MXf2b0_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id

What can I do to improve the page load?

Thanks
Winnie

June 16, 2019 at 4:36 pm #4030961

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi, Winnie.

Since performance issues can be challenging to pinpoint, let's check a few variables and settings to narrow the issue. Please answer as many of these questions as you can. Contact your hosting provider, if necessary.

Please keep WPML, and all its add-on plugins enabled while doing these steps:

1. If you haven't already, can you review the following articles?
https://wpml.org/faq/prevent-performance-issues-with-wpml/
https://wpml.org/2012/01/can-your-site-run-faster/
- Please ensure that all the relevant steps are followed.
You told me that you so OK.

2. Can you please confirm that the following setting is OFF or disabled:
- Track where strings appear on the site (WPML > String translation)

3. Try disabling and re-enabling all WPML plugins and then going to WPML > Support > Troubleshooting and press the "Recreate ST cache tables" button.
The first visit after the re-activation of the plugins is somewhat slow, but after the regeneration of the tables - it will be better.

4. What type of hosting do you have? Shared, VPS, Dedicated, etc.?

5. Do you know if object caching is part of your PHP setup?
PHP < 5.5 should be APC. Newer versions should use the Zend op cache, uAPC will also work though but is slower.

6. Can you confirm that you are still experiencing performance issues with minimal set up (all plugins except WPML disabled and the theme on a WordPress default such as Twenty Fifteen)?

7. Please make a test with and without WPML on any of these services:
tools.pingdom.com, gtmetrix.com and google pagespeed insights, as they may help you to evaluate the real impact of WPML on your page speed.

Thank you for helping us pinpoint the issue. Feel free to add any other information you may have.

Regards,
Itamar.

June 16, 2019 at 6:06 pm #4031021

winnieV

Hi Itamar,

Thanks for you response.

I've been through all the steps, and here are my answers:
1. Ok
2. setting is OFF
3. No slowdown after regeneration, nor a performance improvement
4. The website is running on a VPS with following specs:
- CPU: Intel Xeon E312xx (Sandy Bridge) (4 core(s))
- Memory: 8 Gb
- Version Plesk Onyx v17.8.11_build1708180301.19 os_Ubuntu 16.04
5. PHP 7.3.6 is used with opcache enabled.
6. All standard themes were deleted for obvious reasons. I'd rather not install them back.
7. I've done some thorough testing under different circumstances:
- Cloudflare + WP Rocket + Clearfy
- Cloudflare in dev mode + WP Rocket + Clearfy
- Cloudflare in dev mode and no WP caching
The testing was executed multiple times on two different pages: homepage (with ads and images), general terms page (no ads, no images).

Here are the results:

Pingdom
without WPML: avg. 618 ms
with WMPL: avg. 1463 ms (x2,4)

GTMetrix (pagespeed, yslow, fully loaded time)
without WPML: 93% // 88% // 3.1s
with WPML: 80% // 86% // 4.5s (+45%)

Query Monitor Plugin (no caching)
without WPML: 0.83s
with WPML: 3.06s (x3,7)

I think we need to further investigate what's the cause of the performance gap.

Regards
Winnie

June 16, 2019 at 7:00 pm #4031057

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi, Winnie and thanks for following my suggestions.

I want to check a few things on your site.
You wrote that you had executed the checks on the homepage and the general terms page.
Could you please tell me where I can see the slow queries that you have added in your first post of this thread?

If you need further help with this, please share the access details to your site with me.
I'm enabling a private message for the next reply.

Privacy and Security Policy

We have strict policies regarding privacy and access to your information. Please see:
https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

**IMPORTANT**

- - Please make a backup of site files and database before providing us access. --

Thanks,
Itamar.

June 17, 2019 at 7:06 pm #4038135

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi and thanks for the access details.

I've checked your site, and I can see two things that need to be corrected.

A. We have released new versions recently. WPML and its add-ons are slightly not updated on your site. Please see the attached screenshot needs-update.jpg.
Please, update WPML and its add-ons.

B. You have not included all the text domain in the Auto register strings for translation section as advised in our documentation here.
https://wpml.org/faq/prevent-performance-issues-with-wpml/#4-auto-registering-strings-for-translation
Please see the attached screenshot include-all-text-domains.jpg
Please include all text domains.

Please check if the above procedures help to improve the performance of your site.

If not, then I'll need to consult our second tier supporters about this issue. For debugging the issue, I might need to create a copy of your site. For this, I will need to install the DUplicator plugin. Please allow me to take a copy of your site, in case it is needed.

Thanks,
Itamar.

June 17, 2019 at 8:32 pm #4038613

winnieV

Hi Itamar

Thanks again.

Here are my answers:
A. Could it be that the update has been released very recently (a couple of hours ago this was not yet available). Of course, I've installed it.
B. Now all text domains are included. Probably I forgot those while testing.

After these changes I can see a slight improvement with query monitor (without caching):
- without WPML: avg. 0,88s
- with WPML: avg. 2,71s (x3,1)

However, the difference is still huge.

Surely I have no issue with you installing the duplicator plugin and making a copy of the site if needed.

Regards
Winnie

June 18, 2019 at 11:20 am #4043081

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi, Winnie and thanks for updating WPML and including all text domains.

I've checked things on your site and also already made a copy of it with the DUplicator plugin in case it will be needed to debug the issue further. I think that there is an issue with taxonomies (post categories and tags) on your site. I say that because I mostly get the following query as a slow query.

SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy
FROM xxxxx_icl_translations wpml_translations JOIN xxxxx_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN xxxxx_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id

I can see that you have a lot of post categories and tags. I'm consulting our second tier supporters about your issue. But meanwhile, I would also like to ask you to try our troubleshooting section.
First, take a backup of the DB of your site.
- Go to WPML -> Support -> Troubleshooting (link)
Once on the troubleshooting screen press the following buttons and check if it helps.
Press each button at a time and wait for the process to complete.
- Synchronize posts taxonomies (for each of the post types).
- 'Set language information'
- 'Fix terms count'
While you are on that section, please also try the other buttons. Just be careful not to reset WPML at the bottom of this screen.
Then please check if it improves the performance and reports to me.

*** Please make a backup of your database before using this.***

Thanks,
Itamar.

June 18, 2019 at 12:56 pm #4043925

winnieV

Hi Itamar

I've following all your instructions, but to no avail.

Here are the results:
- benchmark before starting: avb. 2,44s
- synch taxonomies: avg. 2,48s
- set language info: avg. 2,68s
- Fix terms count: avg. 2,50s
- all other 'fixes' + clearing wpml cache + waiting awhile for the cache to do its job: avg. 2,80s
- after these fixes + disabling WPML: avg. 1,13s

So, still there is no real improvement.

Regards
Winnie

June 18, 2019 at 2:49 pm #4044561

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Thanks, Winnie for trying my suggestion.

I'm waiting for our second tier supporters reply. When I have more information, I'll share it with you here.

Thank you for your patience.
Itamar.

June 19, 2019 at 6:46 pm #4054037

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi.

I've escalated this issue to our second tier supporters. They will assess the performance issue on your site and try to find its source. I'll keep you updated here.

Thank you for your patience.
Itamar.

July 16, 2019 at 2:04 pm #4220847

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+03:00)

Hi.

Our developer has checked this issue on your site and concluded that the problem is with the Query Monitor plugin. Together with WPML, it produces a huge impact on page loading time. The recommendation here is to deactivate this plugin on the production site.

Please let me know if this solves the issue.

Regards,
Itamar.

The topic ‘[Closed] Improving performance’ is closed to new replies.