i'm seeing a regular occurrence of slow queries on our site. Are these something to do with WPML?
SELECT post_id FROM wp_postmeta p JOIN wp_icl_translations t ON t.element_id = p.post_id WHERE p.meta_key=? AND p.meta_value=? AND t.element_type=? AND t.language_code=?
SELECT ID FROM wp_posts p JOIN wp_icl_translations t ON t.element_id = p.ID WHERE t.element_type=? AND t.language_code=? AND p.guid=?
SELECT p.post_id FROM wp_postmeta p JOIN wp_icl_translations t ON t.element_id = p.post_id WHERE p.meta_key=? AND p.meta_value=? AND t.element_type=? AND t.language_code=?
Just did some further tests, one of which being WPML enabled vs disabled and the English version of the site gets about a second quicker with WPML disabled.
This is in addition to the constant large query we see running (attached).
Thank you for contacting WPML support, I'd be happy to help you with this issue.
It could be an issue with slowness caused by one of the plugins not being compatible with WPML or some theme code.
Can you please follow the next steps and let me know how it goes:
Please make a backup before proceeding.
1) Install the Query Monitor plugin (https://wordpress.org/plugins/query-monitor/)
2) Check the load time and the number of queries in the top bar. Load time has "s" and queries "Q"
3) Disable all WPML plugins and check load time and the number of queries now
4) Disable all other plugins and leave active only WPML plugins, switch to a WordPress default theme. Check again.
Please let me know how it goes and shares each result with me and read more on the documentation https://wpml.org/tutorials/2019/10/analyze-performance-issues-with-query-monitor/
I also need more information on your site by sharing the debug info. If you don’t know how to share the debug info, please follow this article https://wpml.org/faq/provide-debug-information-faster-support/
Your next reply is enabled to share the debug info.
Look forward to your reply.
Thanks
The topic ‘[Closed] Slow queries on site’ is closed to new replies.
