PluginUs.Net - Business Tools for WooCommerce and WordPress

[realize your idea - make your dreams come true]

Support Forum

You need to log-in to create request (topic) to the support

Slow Queries

The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page please
If you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.

Hi Support,

I'm having an issue with some slow queries related to price and I have already enabled the Optimize Price Filter and actually removed the price filter altogether trying to debug the issue. Also, we are on the latest versions of everything (your plugin, WC, WP, etc) and PHP 8.1. We are running a database of 5,000+ products and 50,000+ variations but the VPS is no slouch running 6 core high frequency vcpu and 24 GB RAM. I tried turbo mode, but it would never come close to completing the index file required, which after reading some of your forum posts, it sounds like that might not help at this level of variations and products anyway. However, I would like to solve these query issues and speed up the site. You can see from the Query Monitor screenshot what the queries are that are reportedly slow. I'm not sure the purpose of this query since I eliminated price filtering altogether or how to speed this up. If I'm reading it right, the two slow queries are duplicate queries as well. Right now object caching is not enabled, but will be in the live environment.

https://prnt.sc/fD6pSGtEY3t3

Please advise on how to fix this.

Thank you!

Hello

Please  drop  me exact  link to the  issue

Our site is not yet live so I can't drop you a public link. I can email you a link and credentials to access our sandbox site. Please let me know the best email for that.

Our sandbox site is not having an issue with those queries being super slow, but they only have a small amount of products compared to the live site. The queries are still running though.

Hello

To add  any  private  data - https://share.pluginus.net/image/i20230222134241.png ->https://share.pluginus.net/image/i20230222134615.png