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: Performance
This topic contains 54 replies, has 3 voices.
Last updated by Andreas W. 1 year, 4 months ago.
Assisted by: Andreas W..
Author | Posts |
---|---|
August 15, 2023 at 6:57 pm #14205083 | |
Bobby Supporter
Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00) |
All you need to do is run the following query: ALTER TABLE `wp_postmeta` ADD INDEX `meta_value` (`meta_value`(191)); First make sure you create a backup in place and then go to your database and run the above SQL Query this will add the index. Once done let us know your results, if all is OK you can delete the testing site |
August 16, 2023 at 1:57 pm #14236857 | |
thomasV-73 |
Dear Bobby, I am not a programmer. Can you please tell me where I find this database? |
August 16, 2023 at 6:32 pm #14240743 | |
Bobby Supporter
Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00) |
I would advise asking the hosting provider to perform this or a developer on your team otherwise I would be happy to do it as long as you give me permission and have fully backed up your site and database before proceeding. |
August 21, 2023 at 8:54 am #14261287 | |
thomasV-73 |
Can you please do it for me? As my webhost is currently on vacation. Can you make the next reply have the hidden option? |
August 21, 2023 at 6:13 pm #14266415 | |
Bobby Supporter
Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00) |
Yes, of course! Private reply enabled |
August 23, 2023 at 5:30 pm #14280025 | |
Bobby Supporter
Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00) |
Thank you for the access details! I have run the SQL Query. |
August 24, 2023 at 8:13 am #14282493 | |
thomasV-73 |
Dear Bobby, So to be clear, it means it is active now and I can test it with WPML? |
August 24, 2023 at 5:31 pm #14287581 | |
Bobby Supporter
Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00) |
Yes it is, please let us know your results |
August 28, 2023 at 10:17 am #14299439 | |
thomasV-73 |
Dear Bobby, Thanks. I ran the following tests in 3 different ways: The speed tests I ran were: --- The results I came to where: wether the queries were on or off didn't seem to make an impact on the speed (atleast while WPML was off). Then, when I turned WPML on (and the queries were on), it showed significant speed decrease. I made 3 screen recordings comparing the situations. Would you like to see them? I can't upload them here because you can only upload images. You have any suggestions for uploading them? |
September 2, 2023 at 3:15 am #14329417 | |
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00) |
Hello, My colleague Bobby is currently on vacation and I would like to assist you on this matter. You can use WeTransfer to send me the videos: When uploading the file you can use the settings section and get a download link, instead of sending the file to an e-mail address. If you prefer to send them to an e-mail, feel free to use: Further, as the provided test site on this ticket is no longer available, I am taking a copy of your site with All In One WP Migration as I am just jumping in on this ticket and would like to run a few tests myself to make myself a picture of this issue. From what I see in our internal thread this is more of a backend issue and the load time for all products with WPML takes 4-10 seconds longer to lead the list, correct? Take note, that our developer suggested using the new HPOS feature from WooCommerce (Custom Table for Products) which is compatible with our addon WCML and should definitely enhance the performance, as then the product will no longer use the default WordPress Posts Table - do I understand right, that this is not an option for you? Best regards |
September 2, 2023 at 9:56 pm #14330863 | |
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00) |
Hello, I created a local copy of your website, but take note that I do not have any test environment for a Litespeed server - I am testing on NGINX using PHP 8.1 and MySQL 8.0. I had to remove the plugin "WP 2FA - Two-factor authentication for WordPress" as it will not work on localhost. I have also set the WP MEMORY LIMIT to 265M on my test. Now, first I see 4 available updates on the website for WooCommerce and other plugins that I ran. I also removed such plugins that on this current copy were disabled, apart from WPML and its add-ons, and removed backups on the server side (Duplicator, AIO WP Migration, unnecessary zip-archive from Elementor PRO,...) A dashboard dialog further asked for a WooCommerce Database update, which I completed. Then I installed the plugin Query Monitor. Take note, that even when running without WPML WooCommerce is throwing this Notice: Deprecated This PHP Notice should not really harm your site for now but it refers to an issue that might occur when updating the server to the upcoming version of PHP. Usually, the dev teams keep track of such notices, and try to fix them before a new PHP version is released. TESTING PERFORMANCE: If I disable all plugins and test only with WooCommerce the page loads in 2.20 Seconds. Further, there is a slow query that is actually coming from WooCommerce and also occurs if only WooCommerce is enabled: SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND ( wp_posts.post_date_gmt >= '2023-06-04 21:34:59' ) AND wp_posts.post_type IN ('shop_order', 'shop_order_refund') AND ((wp_posts.post_status = 'wc-processing' OR wp_posts.post_status = 'wc-completed')) ORDER BY wp_posts.post_date DESC LIMIT 0, 1 When activating all plugins apart from WPML and visiting the Products > All Products page without WPML the site loads in 6.65 Seconds. This means that even without WPML we have more than 4 seconds more load time. Then, take note that WPML Multilingual CMS and WPML String Translation were not updated on the copy of your site so I updated our plugins and activated them in order to test only with WooCommerce WPML, String Translation, WPML Media, and WCML. The page Products > All Products is loading in 3-4 seconds in such a minimal setup. I do actually see here two more slow queries coming from WPML and String Translation, apart from the one coming from WooCommerce, but the impact of those queries is very low, with less than 0.2 seconds. The same counts for WooCommerce > Orders which also loads in 3-4 seconds. This is why at this point I can not confirm any performance issue when using only WooCommerce and WPML plus addons all in their latest available versions. Finally, I activated all plugins again and the load time was about 6-7 seconds - similar when actually running the site without WPML. This means I can currently not confirm any performance issue caused by WPML. Please update all plugins and test again. Best regards |
September 4, 2023 at 10:36 am #14335773 | |
thomasV-73 |
Dear Andreas, When I ran the tests a week ago everything was up to date. I deleted the testing site. If you want I can make a new testing site. As for the HPOS feature: I cannot use this like I explained to Bobby. Some essential plugins are not compatible with it. On the following lik you can find the 3 videos where I was testing the 3 scenarios: hidden link |
September 5, 2023 at 5:06 pm #14346509 | |
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00) |
Hello, Thank you for your comment and I will have a look into the videos shortly. Yes, I would welcome access to the test site, as it might actually be that this issue is somehow server related and this is why I was not able to confirm it on localhost. The private reply form is enabled again. Here again is my report of the performance test that I ran on Localhost: WooCommerce, WPML Multilingual CMS, and String Translation were not using the latest versions. I updated them before testing. Testing Products > All Products: WC only takes 2 seconds. I can not confirm any performance issues on my local test, as an impact of 1 second is expected with WPML. There is only a deprecated Notice from WC and three slow queries (one from WC and two from WPML), but their impact is 0.3 seconds. Best regards |
September 9, 2023 at 11:54 pm #14370271 | |
Andreas W. Supporter Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00) |
Hallo, Wie ich zuvor sagte, ich hatte bereits eine lokale Kopie der Website angelegt, dort alles aktualisiert und konnte kein Problem feststellen, welches durch WPML verursacht wurde. Auf Deiner Test-Site waren mehrere Updates verfügbar, auch WPML ist nicht aktualisiert. Versuche ich die Updates auszuführen erhalte ich einen Fehler: 503 Service Unavailable Dieser Fehler liegt hier in der Tat nicht an WPML, da das Plugin aktuell nicht aktiv ist. Bitte untersuche dies und gib mir Bescheid sobald auf der Test Site alle Plugins aktualisiert sind. Für das Astras Theme sollte ebenfalls ein Update verfügbar sein - installiert 4.1.5 - aktuell 4.3.1. Mit freundlichen Grüßen |
September 10, 2023 at 6:11 am #14370453 | |
thomasV-73 |
Dear Andreas, I just updated everything included the theme |