I am using Chinese as main language, but I found that English is really slow. I installed Query Monitor, I found that this SQL query used 90s to process
SELECT wp_test_posts.ID
FROM wp_test_posts JOIN wp_test_icl_translations wpml_translations
ON wp_test_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_test_posts.post_type)
WHERE 1=1
AND (wp_test_posts.ID = '5937')
AND wp_test_posts.post_type = 'page'
AND ( ( ( wpml_translations.language_code = 'en'
OR ( wpml_translations.language_code = 'zh-hant'
AND wp_test_posts.post_type IN ( 'post','page' )
AND ( ( (
SELECT COUNT(element_id)
FROM wp_test_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en' ) = 0 )
OR ( (
SELECT COUNT(element_id)
FROM wp_test_icl_translations t2 JOIN wp_test_posts p
ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND ( p.post_status = 'publish'
OR p.post_status = 'private'
OR ( p.post_type='attachment'
AND p.post_status = 'inherit' ) ) ) = 0 ) ) ) )
AND wp_test_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','bxslider' ) )
OR wp_test_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','bxslider' ) )
ORDER BY wp_test_posts.post_date DESC
I run the same SQL query in sometimes, it is fast response. May I know what is the issues?
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
Hello,
According to the query, there is an issue with creating a translation for the page with the ID 5937.
Could you please have a look at your pages list and let me know which page is having an issue with its translation? Please send me the name of the page or the link to the original content on Frontend.
From the WordPress Dashboard:
1) Log in to your WordPress admin dashboard.
2) Navigate to Pages (or Posts if you’re looking for post IDs).
3) Locate the page you want to find the ID for.
4) Hover your cursor over the title of the page.
5) Look at the left bottom corner of your browser window where you will the page's URL in your browser. Somewhere in the middle, you’ll see something like this:
Languages: English (English )Spanish (Español )German (Deutsch )
Timezone: America/Lima (GMT-05:00)
It seems that this site is not using WPML's Advanced Translation Editor which is why I can not look up the job on our system. You must be using the Classic Translation Editor instead.
I would like to offer to have a closer look at the problem and request temporary access (wp-admin and FTP) to the website to investigate this issue further.
You can find the required fields below the comment section when you log in to leave the next reply. The information you provide is private, which means only you and I can see and access it.
IMPORTANT
Please be sure to make a backup copy of the website and database before allowing us access.
If you can't see the wp-admin / FTP fields, your post and website credentials are set as PUBLIC. DO NOT publish the data unless you see the required wp-admin / FTP fields.
I may have to install a plugin called "All In One WP Migration" to make a copy of the website where I can investigate the issue further.
However, I would also be very grateful if you could provide a staging site or copy of the website from your server yourself for this purpose.
If you have any questions about creating such a staging site, you can consult your hosting provider. Just take note that WPML should be registered on this site again.
If you are unable to provide such a copy of the site for testing, please let me know on this ticket.
The private response form looks like this: hidden link
Next time you reply, click "I still need assistance."
Video: hidden link
Please note that we are obliged to request this information individually on each ticket. We may not access any access information not specifically submitted on this ticket in the private response form.
If you earlier used the Classic Translation Editor for creating the translation, then please set this option again.
If this will not solve the issue, please let me know.
Best regards
Andreas
The topic ‘[Closed] page loading slow issues’ is closed to new replies.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
