Background queries slowing down my site. Coming up on each refreshs

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.

This topic is split from https://wpml.org/forums/topic/woocommerce-analytics-report-not-downloading-for-other-currency-speed-issue-at-admin-side-2/

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	-
-	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	-

Supporter timezone: Europe/Vienna (GMT+01:00)

Tagged: Bug

This topic contains 4 replies, has 2 voices.

Last updated by sagiS 11 hours, 17 minutes ago.

Assisted by: Bigul.

Author	Posts
November 6, 2024 at 2:19 pm #16372518
sagiS	Hello, I have also reported second issue i.e "What steps can I take to address the speed issue at the admin side caused by background queries?". So your team has checked this issue or not? We are facing admin side speed issue because of WPML background queries running. Please update me for this issue ASAP.
November 6, 2024 at 2:21 pm #16372531
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Welcome to the WPML support forum. I will do my best to help you to resolve the issue. To make sure about the performance issue you mentioned in the chat, it will be related to the following ticket, am I correct? Please confirm. https://wpml.org/forums/topic/background-queries-slowing-down-my-site-coming-up-on-each-refresh/ Also, is it okay to test the performance issue in this staging site - hidden link? -- Thanks! Bigul
November 6, 2024 at 4:52 pm #16374105
sagiS	Hello, Yes, the ticket you mentioned above is correct. Yes, you can test on the same staging I shared with you. Please update me ASAP as we are facing this issue from long time and it is slowing down admin side pages like users & woo orders specially. Thanks
November 7, 2024 at 7:49 am #16375387
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+01:00)	Hello, Thank you for the updates. We hope the issue exists in your live site after WPML and WooCommerce Multilingual Troubleshooting procedures and the steps suggested in the following errata. https://wpml.org/errata/wpml-causing-backend-slowness-and-duplicated-queries/ Can you reproduce the issue in a minimal setup on the staging site now? Becuase now in the staging site only WPML plugins and WooCommerce are active with the default 2023 theme. It will help us a lot in debugging. -- Thanks! Bigul
November 8, 2024 at 2:31 pm #16382433
sagiS	Hello, I have seen the errata article earlier. At that time also I cleared all the backgroud tasks but the speed issue was not solved. Yesterday I checked the table icl_background_task, I have seen 3 tasks and truncated the table again. But the speed issue still exist and taking more time on these admin side pages like users & woo orders. Also please provide me the answers of following questions ASAP : 1. inside admin WPML->String Translation [ hidden link ] - How to stop these translations? currently it is showing translation in progress and I cant edit these strings from String Translation. 2. Some requests on Admin->Users page, taking more time and I want to stop those requests. Is this possible from any setting inside admin side? [ hidden link ] this request is from WPML and it has taken 8 seconds 3. Screenshot - [ hidden link ] each request is of WPML and taking 7-8seconds which is not good. 4. check this sync request - [ hidden link ] 5. check this retry request - [ hidden link ], why these are coming on users admin page ? and taking more time like around 7 seconds. How to stop these requests ? 6. Why this request is coming on Admin Woo Orders Page? GetJobsCount [ hidden link ] it is taking mostly around 25-30 seconds, see inside screenshot - [ hidden link ] 7. on woo orders page, see retry job request - [ hidden link ] Please give an appropriate answer to me for the above 7 questions ASAP. If you don't know then please consult to your senior developer and let me know the possible solution so that I can do on my production environment.