[Waiting for user feedback] Severe performance regression after updating WPML — DB CPU spikes & resource usage ~2x

Hi Mikheil,

I just wanted to inform you that our 2nd-tier support spent some time on this and we have the points below:

- The tool you provided to us does not allow to index specific post, and it works for the whole website that takes a long time for us and it did not provide the information that could be helpfull.

- 2nd tier found out that by commenting out the code below:

if( QFIP_SLT_licence::verify_wwt_domain() ) {
	define( 'QFIP_APP_API_URL', '<em><u>hidden link</u></em>');
}
else {
	define( 'QFIP_APP_API_URL', '<em><u>hidden link</u></em>');
}

On this plugin file:

/wp-content/plugins/quick-featured-images-pro/quick-featured-images-pro.php

It boosts the performance significantly.

There was another point regarding WPML SEO plugin impact that is reported to the development team.

Making improvements there will take time as the dev team need to work on that and make sure it will be considered as an official release.

Thanks.

Hello,

sharing some more updates from our side:

Try limiting the posts that are queried per sitemap chunk.

This can be limited by:

/* Limit the number of sitemap entries for Yoast SEO */
function max_entries_per_sitemap() {
    return 100;
}

add_filter( 'wpseo_sitemap_entries_per_page', 'max_entries_per_sitemap' );

as per their documentation: hidden link

This will create MORE sitemaps, but the queries that are going to be done will be less expensive per sitemap chunk and in fact less CPU usage.

If you prefer optimizing the sitemap instead, you can disable the feature by adding define( 'WPML_SEO_ENABLE_SITEMAP_HREFLANG', false ); in the wp-config.php file.

In parallel, re-activate the HREFLANG in the HEAD.

https://wpml.org/documentation/plugins-compatibility/using-wordpress-seo-with-wpml/#:~:text=each%20language).-,Using%20Hreflang%20Tags,-By%20default%2C%20WPML

let me know how it goes.

Regards,
Drazen

Hello,

1) I would advise installing older version of WPML, but you can find it under downloads under changelog:

- https://wpml.org/download/wpml-multilingual-cms/?section=changelog
- https://wpml.org/download/wpml-string-translation/?section=changelog

2) Were you able to try and check our suggestion shared? Did that help?

Please let us know.

Regards,
Drazen