Really slow back-end. Issue WPML (9 languages ) - String translation Plugin

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.

Tagged: Compatibility

This topic contains 18 replies, has 2 voices.

Last updated by Waqas Bin Hasan 1 year, 10 months ago.

Assisted by: Waqas Bin Hasan.

Author	Posts
February 16, 2023 at 2:25 pm #13049867
royv-8	Hi, The back-end of a client website is really slow! We setup a test envoriment and we see a lot of duplicate queries most of them are form WPML. Also without WPML the website is super quick. We have credentials for you if you like.
February 17, 2023 at 4:40 am #13054389
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for contacting the support. I see that you are using an older version of WPML Multilingual CMS, can you please upgrade to the latest stable version and then try again? It is strongly advised to use the latest versions of plugins and themes. IMPORTANT: Take full backup of your website and database beforehand. It is highly advised to try the following on a staging/dev site first, so your live website isn't compromised. You can try this by going to Plugins -> Add New -> Commercial -> Check for updates or manually downloading from https://wpml.org/account/downloads/ and uploading via Plugins -> Add New -> Upload. Steps to update plugins manually from Plugins page: 1) Deactivate existing WPML plugins 2) Delete WPML plugins 3) Download latest versions from https://wpml.org/account/downloads/ 4) Upload using Plugins -> Add New -> Upload 5) Activate Steps to update plugins manually via FTP: 1) Deactivate existing WPML plugins. 2) Connect to your site via FTP and browse to the /wp-content/plugins/ folder. 3) Delete WPML plugins folders. 4) Download the latest versions from https://wpml.org/account/downloads/. 5) Unzip the downloaded files in separate folders, usually when you unzip the file, it creates a folder with the name of the plugin, with zip file's content extracted into it. 6) Upload the extracted (unzipped) folder via FTP, to the /wp-content/plugins/ folder. 7) Go to WP Admin -> Plugins and Activate. Please let me know. Regards.
February 17, 2023 at 8:31 am #13055169
royv-8	Hi Waqas, We are working on a staging website called staging.mvgm.com. We updated the plugin and reactivated string translations, but no issue is fixed. The issue =WPML and the add-on for string translations. I can give you full access, this issue needs to be fixed 🙂 Hereby a video from the back-end where I deactivated all plugins and activated PODS.io for CPT and after that WPML followed up by String translations: hidden link I need help, I dont know how this is even happening. Without WPML its working good! We are on the highest package. 16gb RAM, 512memory limit, php 8+, input_vars 10000, exc. time for scripts 120. No heavy plugins except PODS.io and WPML. But without WPML the website works perfect.
February 17, 2023 at 12:21 pm #13057027
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for the updates and the screen recording. Duplicate queries may occur due to some reasons like: - Lot of posts - Lot of posts meta - Above mentioned multiplied with number of languages - Too large icl_* tables (i.e. icl_translate, icl_translate_job, icl_translation_status) - 3rd party plugins/theme manipulating content combining with WPML activity - and so on... At this point, after consulting our support forums and guides at hand, I 'll suggest to try the followings: IMPORTANT: Take full backup of your website and database beforehand. It is highly advised to try the following on a staging/dev site first, so your live website isn't compromised. 1) As a simple start, please look at this thread https://wpml.org/forums/topic/lots-of-duplicate-queries-with-woocommerce/#post-11434503 and see if this helps? 2) Try some WPML Troubleshooting options (https://wpml.org/documentation/support/wpml-troubleshooting-options/), specially clearing WPML cache, removing ghost entries, cleaning and optimizing string tables and etc. 3) For reducing size of icl_* tables, see this errata https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/. I recommend checking the size of tables in DB first and decide accordingly. The referenced plugin can be downloaded from hidden link if needed. 4) Check with only WPML plugins active, and, check if issue occurs straight from WPML plugins only. Because PODS plugin isn't on our compatibility list (https://wpml.org/plugin/?wpv_view_count=120064&wpv-plugin-functionality=0&wpv_post_search=pods&wpv-wpcf-recommendation-flag=&wpv_filter_submit=Search). We have some reports (very few) around PODS vs WPML handling of custom fields but those are still in open and found no significant improvement (in terms of compatibility). You may want to contact PODS support, if the issue happens only when the said plugin is active. 5) Considering the above workouts, also check with a default WordPress theme (i.e. 2023 or 2022) vs WPML only (and then with PODS activated as well). This 'll help ruling out the suspects coming from the theme (by any chance). 6) In your screen recording, I noticed that there's a WPML notice stating "WPML plugin cannot connect to wpml.org". Although this shouldn't be relevant but doesn't harm to check if there are any security modules installed on your website? Because the server might be blocking some requests. Please have a look at https://wpml.org/faq/wpml-plugin-cannot-connect-to-wpml-org/ for details. This may be a temporary issue or a false-positive. You can also try to force the connection to wpml.org, by going to Plugins > Add new > Commercial tab and click the button "Check for updates". 7) Till this point, if none of the above helps, please provide admin access to your website to check the issue in detail? You can create a separate admin user for this purpose, which can be deleted afterwards. Also provide following detail to investigate/observe the issue: - detailed steps to reproduce the issue - links to pages in admin and on frontend - screenshots or screen recording if needed to explain - any other relevant information to observe/investigate the issue Remember to take full backup of your website and database before proceeding. However, a staging/test site is highly recommended, because I may need to try some changes/fixes on the site, which may cause conflicts with the live site otherwise. Please confirm it in your next reply or let me know if you do not agree with the mentioned. I've set your next reply as private to share this information safely. IMPORTANT: If you don't see the section for providing access information, do not write in the message box or the information may appear as public. See https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ for details on privacy and security. Before continuing on the site, I'll also need your confirmation and approval on each of the followings: 1) Is this a Live/Production or Staging/Dev site? 2) Is it OK to work on this site? 3) Is it OK to try some changes/fixes on the site and/or activate/deactivate/install a plugin on the site, which may cause conflicts with the other parts of the site? 4) Have you taken full backup of your website and database? Please confirm, thanks.
February 20, 2023 at 1:27 pm #13070095
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for the access and the confirmations. I am working on this and 'll get back to you as soon as I find something or have a solution. As a starter, I deactivated SEO plugins (Yoast and PODS) and Pages (page listings) loaded faster as compared to when the said plugins were active. For the number of duplicated queries, I am looking into this. I may need to ask 2nd tier for a deeper look inside and for this purpose, they may need a duplicator package of the site with minimal setup. However, I need your approval beforehand because this way they'll be able to figure out the problem more efficiently. Please see https://wpml.org/faq/provide-supporters-copy-site/ for more details. I've set your next reply as private to share this information safely. Regards.
February 21, 2023 at 1:25 pm #13079407
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for the duplicator package. I've set your previous reply as private to keep the download link safe. The minimal setup is kind of a starting point to see if issue is really coming from WPML or with a combination of more plugins (as they are activated one by one for testing). Anyways, I am on it and 'll try my best to get something out of it or 'll ask the 2nd tier team for further investigation (and a solution). I'll keep you posted. Regards.
February 22, 2023 at 6:39 am #13085033
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for your patience on this. I've forwarded the case to our 2nd tier for deeper insights (and perhaps a solution also). I'll update you as soon as I hear back. Regards.
February 23, 2023 at 5:32 am #13094851
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for your patience and cooperation on this. I got some info from the 2nd tier that: > ...could be English language is deactivated instead custom English is activated... However, this needs to be further investigated. So the issue has been escalated and I'll update you as soon as I get more information or solution. Regards.
February 27, 2023 at 4:42 am #13119233
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for your patience and cooperation on this. I got some info from 2nd tier and they suggest the following workaround for now: 1) Remove following from "wp-config.php", since it is disabling WPML cache: define('ICL_DISABLE_CACHE', true); This has been already removed from staging site for testing by the team. 2) Then follow these steps to cache these queries: - Make sure to have a complete site files backup. - Edit the file "wp-content\plugins\sitepress-multilingual-cms\classes\class-wpml-translation-job-factory.php". - Go to line number 315 and replace: $data_prepare = $wpdb->prepare( $data_query, $limit ); $data = $wpdb->get_results( $data_prepare ); with: $cache_key = md5($data_query.$limit); $data = WPML_Non_Persistent_Cache::get($cache_key); if (empty($data)) { $data_prepare = $wpdb->prepare( $data_query, $limit ); $data = $wpdb->get_results( $data_prepare ); WPML_Non_Persistent_Cache::set($cache_key, $data); } - Then go to line number 414 and replace: $elements = $wpdb->get_results( $wpdb->prepare( $query, $job->job_id ) ); with: $cache_key = md5($query.$job->job_id); $elements = WPML_Non_Persistent_Cache::get($cache_key); if (empty($elements)) { $elements = $wpdb->get_results( $wpdb->prepare( $query, $job->job_id ) ); WPML_Non_Persistent_Cache::set($cache_key, $elements); } Meanwhile, there is more testing being done. Please let me know how it goes so I can share the results with the team. Regards.
February 27, 2023 at 9:00 am #13120723
royv-8	Hello Wagas, Great hearing from you! And thank you for this intense testing! I see we have to do some steps. I would like to know what the damage could be if I or we do this wrong? Because we have around 800k visitors a year. Thanks in advance
February 27, 2023 at 10:45 am #13122635
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, I'll advise to try on your staging site first. Once you are confident, then you can apply the fixes on the live site. Remember to take full backup of site and database before applying any change. Apparently, there shouldn't be any damage except if something is wrongly typed or is missing parts from the said code, site may break. So the best approach is to try first on staging, take notes, test and then copy/paste changes on live site. Regards.
February 28, 2023 at 6:36 am #13131277
royv-8	Hello Waqas! Thanks for responding in such short time, great support so far! Today I will follow these steps. I will get back to you if I succeeded or not 🙂
February 28, 2023 at 11:12 am #13134323
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Sure, please take your time and reply when ready. All the best 🙂
February 28, 2023 at 1:12 pm #13135811
royv-8	Hi Waqas, I followed your steps. Wasn't that hard luckily. As you can see the difference on pages with duplicatie queries are less, but loading speed to back-end is still not acceptable. I mean it results in a 502. I believe 2nd tier is still testing everything out right? I will wait patiently. Here I have a wetransfer link with 2 screenshots (query monitor) + 2 videos of the loading time each site results in a 502 timeout hidden link Kind Regards,
March 1, 2023 at 6:27 am #13141575
Waqas Bin Hasan Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)	Hi, Thank you for the updates. I've forwarded to the 2nd tier and 'll update you as soon as I hear back. Regards.