Problem: You are experiencing slow performance on your site, and PHP x-ray reports indicate that WPML is significantly impacting performance. The issue might be related to the database collation settings for the wp_postmeta table. Solution: We recommend altering the collation of your wp_postmeta table to utf8mb4_general_ci to potentially resolve the performance issues. You can do this by executing the following SQL commands in your database:
1
ALTER TABLE `wp_postmeta`<br />CHANGE `meta_key` `meta_key` varchar(255) COLLATE 'utf8mb4_general_ci'NULL AFTER `post_id`,<br />CHANGE `meta_value` `meta_value` longtext COLLATE 'utf8mb4_general_ci'NULL AFTER `meta_key`,<br />COLLATE 'utf8mb4_general_ci';
If this solution does not apply to your case, or if it is outdated, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket at WPML support forum for further assistance.
Problem: The client is experiencing very slow performance on their website. A PHP X-Ray report identified WPML as the root cause. Despite updating WPML from version 4.6.12 to 4.6.13, the issue persisted. Solution: We discovered that the slow performance was due to specific theme code in
. The problematic code is a function designed to update the focus keyword for all posts of a certain type on every page load. Here is the code:
1
// Function to automatically update the focus keyword for all: sights<br />function update_focus_keywords_sights()<br />{<br /> $posts = get_posts(array(<br /> 'posts_per_page' => -1,<br /> 'post_type' => 'sights' //replace post with the name of your post type<br /> ));<br /> foreach ($posts as $p) {<br /> update_post_meta($p->ID, 'rank_math_focus_keyword', strtolower(get_the_title($p->ID)));<br /> }<br />}<br />add_action('init', 'update_focus_keywords_sights');
Removing this code reduced the site's load time from approximately 17 seconds to 4.5 seconds. We recommend removing or optimizing this function to improve performance.
If this solution does not apply to your case, or if it seems outdated, please check the related known issues and confirm that you have installed the latest versions of themes and plugins. If the problem persists, we highly recommend opening a new support ticket at WPML support forum.
