[Escalated to WPML Developers team] options autoload - slow ttfb

1. can we do autoload=no on wpml_cms_nav_Cache? OR disable the cache for wpml_cms_nav_Cache?

2. is wcml_trbl_ranslated_variations mandatory?

we have identified with wpintense scalablity pro team the slow query that is causing us slow TTFB

do you have a solution for this maybe?

SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type FROM lsk_icl_translations wpml_translations JOIN lsk_posts p ON wpml_translations.element_id = p.ID AND wpml_translations.element_type = CONCAT('post_', p.post_type) JOIN lsk_icl_translations tridt ON tridt.element_type = wpml_translations.element_type AND tridt.trid = wpml_translations.trid WHERE tridt.element_id IN (7120333,7120320,7120328,7120349,7120

the issue is that we have 50000 products, and this query is for our category section (turquoize)

at the top of the site

i searced for the ttfb of wpml, and found several users complaining,

can you check if this solution apply to us as well:
1. https://wpml.org/forums/topic/waiting-time-for-the-server/page/3/#post-10604607
OR
2. https://wpml.org/forums/topic/my-site-speed-slow-down-after-wpml/#post-10152591
OR
3. https://wpml.org/forums/topic/my-queries-are-showing-posts-in-all-languages/#post-11015505

did you update any plugins on the site?

if so why? i only asked to fix the slow query

i have removed your access until an answer

ok thank you for confirming, no plugin updates please

i have reopened your access

Bigul

As you saw our backend, we are no kids, so we expect from you don't to give us kids answer about versions
- we have many custom made plugins, again you saw our backend, and thus we have many dependencies , so this is why we don't update every monday and thursday things on our backend

THE PROBLEM IS WITH THE DB QUERY THAT IS NOT OPTIMIZED, we wrote you that the biggest authority in the speed on wordpress, dave from wpintense told you the problem

so our version of wpml or wordpress is not the concern, the concern is to find a more optimized db query for categories

we gave you the query, we also gave you query monitor on our admin

and we also advised that you speak to your 2nd tier support

- did you change anything on our admin by the way, or nothing? because string translation, started not searching for keys