options autoload - slow ttfb

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
-	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	-
-	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	-

Supporter timezone: Europe/Vienna (GMT+01:00)

Tagged: Exception, Performance

This topic contains 69 replies, has 4 voices.

Last updated by Bigul 8 months, 4 weeks ago.

Assisted by: Bigul.

Author	Posts
September 14, 2023 at 3:12 pm #14397955
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Our dev team has confirmed this query is base one and will not be the main cause of the performance issue. 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) As a workaround, you can consider implementing proper object caching, including database caching to improve the performance. The upcoming version of WPML(4.6.7) will be including a performance boost. We are happy to further debug this issue. It would be great if you could create a staging site for our troubleshooting. Please let us know your feedback. Also, please share the current server and the configuration details you are using. It will also help in debugging. -- Thanks! Bigul
September 15, 2023 at 4:39 am #14400299
louisN-4	according to Wpintense the "IN" is that major issue there, and you should simplify the query we would be happy if you give us a workaround for the current version we have, in addition, if you open a private box, i will give you staging access
September 15, 2023 at 7:49 am #14401039
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Thank you for the updates. In our tests, if we remove the IN condition it will list the taxonomies also. So it will not be an ideal solution. I am enabling the private option for the next reply. Please check and share the staging site credentials. -- Thanks! Bigul
September 15, 2023 at 9:35 am #14402127
louisN-4	by the way we already have redis on the server and its not helpful, its only about you optimizing the query
September 15, 2023 at 5:47 pm #14405089
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Thank you for the staging site credentials. We will test it further on the staging site and get back to you as early as possible. Please wait. -- Thanks! Bigul
September 15, 2023 at 6:13 pm #14405157
louisN-4	please try to hurry as much as you can, its killing our business, less sales, and no point of us onloading more products.
September 17, 2023 at 6:10 am #14407463
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Thank you for the updates. I have shared the details with our second-tier team and waiting for their expert opinion. We will get back to you as soon as possible. Please wait. -- Thanks! Bigul
September 19, 2023 at 6:00 pm #14423227
louisN-4	hi bigul, did you get an answer from 2nd tier?
September 20, 2023 at 9:04 am #14427869
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, As per the second-tier team's suggestion to verify the performance, I upgraded the WPML plugins to the latest version(4.6.6) on the staging site and did a few rounds of testing. The page loading is a little better now(improvements of 2-3 seconds in Query Monitor). We will debut it further and get back to you soon. Please wait. -- Thanks! Bigul
September 21, 2023 at 3:40 pm #14440969
louisN-4	do you have for us maybe a redis code to implement to capture this query?
September 22, 2023 at 4:14 pm #14448065
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Thank you for the updates. We are still working on this and get back to you as early as possible. Please wait. -- Thanks! Bigul
September 24, 2023 at 4:38 pm #14453237
louisN-4	any update on this?
September 25, 2023 at 2:03 pm #14459331
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Our second-tier team still working on this. We have a lot of limitations here because of the older version of WordPress, WooCommerce, and other plugins. Our team is looking for possible workarounds. We will get back to you as soon as possible. -- Thanks! Bigul
September 25, 2023 at 2:07 pm #14459455
louisN-4	do you think updating wpml version would help?
September 26, 2023 at 6:18 am #14463037
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, We have already upgraded to the latest version of WPML(4.6.6) on your staging site. There are only little(2-3 seconds) improvements in the page loading now. So please wait for the feedback from our team. Thank you. -- Thanks! Bigul