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.
نستخدم ملفات تعريف الارتباط لتحسين موقعنا الإلكتروني وخدماتنا.
تسمح لنا موافقتك بمعالجة بيانات مثل سلوك التصفح.
قد يؤثر عدم الموافقة على بعض الميزات.
وظيفي
نشط دائماً
مطلوب لكي يعمل موقعنا الإلكتروني ويتواصل بشكل صحيح.
التفضيلات
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
الإحصائيات
نستخدمها لتحليل إحصائيات موقعنا.
المعلومات التي يتم جمعها مجهولة الهوية تماماً. التخزين الفني أو الوصول الذي يتم استخدامه حصريًا لأغراض إحصائية مجهولة الهوية. بدون أمر قضائي، أو الامتثال الطوعي من قبل مزود خدمة الإنترنت الخاص بك، أو سجلات إضافية من طرف ثالث، لا يمكن عادةً استخدام المعلومات المخزنة أو المسترجعة لهذا الغرض بمفردها لتحديد هويتك.
التسويق
تقوم ملفات تعريف الارتباط هذه بتتبع تصفحك لتقديم إعلانات ذات صلة بك.
