[Resolved] WPML STRING TRANSLATION - Website becomes slow when plugin activated

Thank you for the above information.

I am happy to investigate this further but I will note again that our support is limited when it comes to custom themes and custom work overall.

I would like to request temporary access (wp-admin and FTP) to your site to test the issue.
(preferably to a test site where the problem has been replicated if possible)

**Before we proceed It is necessary to take FULL BACKUP of your database and your website. Providing us with access, you agree that a backup has been taken **

I often use the Duplicator plugin for this purpose: http://wordpress.org/plugins/duplicator/
You will find the needed fields for this below the comment area when you log in to leave your next reply.
The information you enter is private which means only you and I have access to it.

NOTE: If access to the live site is not possible and the staging site does not exist please provide me with a duplicator package created with the duplicator plugin.

Thank you,
Bobby

Hi there,

I believe the issue here might be more related to woocommerce rather than WPML String Translation alone. With WPML String Translation deactivated WooCommerce Multilingual does not work and activating it essentially turns the multilingual part of the WC store 'on'

These are some benchmark reports on loading time with WPML String Tranlsation deactivated:

Front end -- 11.27

Admin dashboard -- 11

Store front end -- 11.8s (Displays product categories)

Here they are with String Translation deactivated:

Front end -- 15.22

Store front end -- 24.95s

WPML + WPML ST + Custom Theme deactivated and switched to Twenty23

Store front end -- 5.5s ----> Most likely because nothing loads, the product categories are being pulled by the custom theme.

same thing with the front end homepage, which does not make this test very reliable.

-------------------------------------------

Unforutnately I cannot proceed with these tests as the server is triggering a 504 Gateway Time-out Error after I deactivated the following plugins from step #2

1. Go to WPML->Settings-> Taxonomies Translation -> Review the taxonomies from Bathtub Components - Type (pa_aksesoyar-mpanieras-typo) and on.

Essentially all the ones that are set to Translatable use translation if available or fallback to default language switch to Translatable switch the setting Translatable only show translated items

This setting is known to increase the resources required and can cause performance issues.

After changing these settings, what are your results?

2. Deactivate the caching plugins for now (Once you turn them back on we recommend using only one caching plugin rather than 2)

WP Super Cache
WP-Optimize - Clean, Compress, Cache
Autoptimize
Redis Object Cache
WP Query Monitor (known to interfere with performance issues)

Thank you for updating me !

Doing the following steps on the staging environment I was able to lower the loading time from around 22s to 11s.

1. Go to WPML->Settings->Taxonomies translation-> swt all the theme taxonomies to "translatable"

2. Go to plugins-> deactivate Google tag manager (most likely because we are on a staging server it is having some issues loading properly)

There are a lot of taxonomies that needed to be adjusted, I have share a screencast showing that as Its too many to list here 🙂

hidden link

Let me know your results, please.

I don't believe there is a major impact when changing this setting, but I would make sure that the taxonomies are fully translated from the WPML->Taxonomies dashboard. (From what I can see they are pretty much all translated)

Regarding the performance.

Yes, I can confirm there is still some issues remaining.

I brought the environment down to as minimal as possible and these are my findings:

1s-2s loading speed with WPML String Translation deactivated

6.5s loading speed with String Translation enabled

I have run the following actions:

#1
Run WPML Troubleshooting action in WPML->Support->Troubleshooting as well as Clean up Invalid Strings from String Translation

#2
Woocommerce->WOoCOmmerce Multilingual->Settings->Troubleshooting-> run actions

Sync products "gallery images"
Sync product stock quantity and status
Sync removed product meta from original products to translations

These helped but did not resolve the performance issue.

When running Query Monitor I see the following PHP errors logged.
22,000 errors seem like a lot and could possibly be causing a slow down.

PHP errors 22,000+ deprecated errors

preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated
wp-content/plugins/wpml-string-translation/classes/slug-translation/custom-types/wpml-st-slug-custom-type.php:69

This was a known deprecated issue that was resolved in WPML 4.6.5
https://wpml.org/errata/php-8-1-preg_match-passing-null-to-parameter-2-subject-of-type-string-is-deprecated/

Are you able to change the PHP version on the staging site? Please change it to a different version, PHP 7.4 if possible just for testing purposes.

There are also some duplicate queries but these are not so significant to add that much load time -- We will however, investigate them further.
Duplicate queries:

SELECT value
FROM wp_icl_strings
WHERE context = 'WP Endpoints' 14 0.0012 WPML_Endpoints_Support->is_registered()
14 calls
Plugin: sitepress-multilingual-cms
14 calls
WPML_Endpoints_Support->add_endpoints_translations()
1 call
apply_filters()
12 calls
WPML_Endpoints_Support->translate_endpoints_in_rewrite_rules()
1 call

I also added the following to prevent the errors from being logged in your wp-config.php in the meantime.

ini_set('display_errors','Off');
ini_set('error_reporting', E_ALL );
define('WP_DEBUG', false);
define('WP_DEBUG_DISPLAY', false);

Thank you, the php erros are removedd but it did not have the effects I expected.

Is it possible to access the database for the staging site?

The next step is to review the icl_ tables to make sure everything is OK.

Using plugins such as phpmyadminer or adminer I keep getting 403 errors.