Skip Navigation

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.

Sun Mon Tue Wed Thu Fri Sat
5:00 – 13:00 5:00 – 13:00 5:00 – 13:00 5:00 – 13:00 5:00 – 13:00 - -
- - - - - - -

Supporter timezone: Africa/Cairo (GMT+02:00)

Tagged: 

This topic contains 10 replies, has 2 voices.

Last updated by Osama Mersal 1 year, 2 months ago.

Assisted by: Osama Mersal.

Author Posts
January 8, 2024 at 10:31 am #15159602

thomasD-100

Hi, we are facing an issue with sitepress-multilingual-cms. When we check the query monitor, we see it takes a lot of time to load the components and the website runs, unfortunately really slow

January 8, 2024 at 10:46 am #15159697

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Could you please check if the issue persists in a minimal environment by following these steps?

1- Deactivate all the plugins except WPML CMS.
2- Switch to a WordPress default theme like Twenty Twenty-one.

If the issue is gone, activate them one by one to see which one is causing an interaction issue.

❌ Please backup your database before performing the above test ❌

Best regards,
Osama

January 8, 2024 at 4:16 pm #15161866

thomasD-100

Hi,

I deactivated all the plugins except WPML CMS and changed default theme.
Unfortunately we have still faced the issue.

January 8, 2024 at 5:10 pm #15162116

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

I would need to look closely at your site, so I would need to request temporary access (WP-Admin and FTP)
Preferably to a test site where the problem has been replicated.

Your answer will be private, meaning only you and I can access it.

❌ Please backup your database and website ❌

✙ I would need your permission to de-activate and re-activate the Plugins and the Theme and change configurations on the site. This is also a reason the backup is critical.

✙ I also need your permission to take a local copy of your site to debug the issue without affecting your live site.

Best regards,
Osama

January 10, 2024 at 2:36 pm #15169426

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

1) Thanks for the access details. I ran a speed test with and without WPML. (Kindly check the attached screenshot)

The difference between the two is 8 seconds, which is acceptable because WPML is an extensive plugin with many queries to run depending on the size of your site.

Please let me know if you face the issue triggered by specific actions, for example, updating pages/products.

2) Please check "Autoloaded" data from the wp_options table, as some big autoloaded keys might create performance issues. Use a query like the following (size will be in KB).

SELECT option_id, option_name, sum(char_length(`option_value`))/1024 as size FROM `wp_options` WHERE `autoload` = 'yes' GROUP BY option_id ORDER BY size DESC

Please note that you need to change the database prefix (wp_) in the query to your database prefix.

Best regards,
Osama

2024-01-10_16-28-06.jpg
January 10, 2024 at 4:06 pm #15170120

thomasD-100

Hi,

sorry for the question but where should I check "Autoloaded" data from wp_options table?
I have never checked the wp_options table. Could this be a cause of the site's slowdown problem?

Best regards,
Enrico

January 11, 2024 at 8:09 am #15172566

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi Enrico,

The wp_options is a database table. If you are unfamiliar with databases, please ask your host support to check it.

Best regards,
Osama

January 11, 2024 at 2:08 pm #15174998

thomasD-100

Hi Osama,

I checked the wp_options.
What I see is that we have 4.448 autoloader options with 19,5 MiB.
Autoloaded yes: 3548769 bytes
Autoladed no: 4215548 bytes

Using the query you suggested here are the results (the top 25 of the 2907 records):
hidden link

I think this could be one of the main problem why the website takes a long time to load the pages. It looks like sometimes we face a performance bottlenecks. If I check PageSpeed Insight or GtMetrix the misured values are good but the website sometimes takes a lot of time to load a single page (especially in the back end).

Bildschirmfoto 2024-01-11 um 14.37.17.png
January 11, 2024 at 2:12 pm #15175038

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for your update. Please take a database backup and delete the top 4 records in the screenshot.

After that, please update WPML to the latest version. You can download it from this page. (https://wpml.org/account/downloads/)

The last version of WPML CMS and String Translation contains some performance improvements.

Kindly let me know if the above steps helped you fix the issue.

Best regards,
Osama

January 17, 2024 at 9:00 am #15193547

thomasD-100

Hi,

so I deleted the records and updated WPML but the problem persists

January 17, 2024 at 9:14 am #15193590

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

1) I can't access the test site, so please check if it's still available.

2) Would you please let me know if any specific steps or actions trigger the issue?

The difference is acceptable when checking with PageSpeed Insight with and without WPML.
Also, when I had access, I didn't face the issue in the dashboard while browsing or editing exciting posts/pages.

Thanks,
Osama

The topic ‘[Closed] Performance issue’ is closed to new replies.