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

Turbo Mode - maximum product count

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.
Joel(@joel-2)
2 Posts
Customers
March 6, 2023, 12:20

Hello

Hope you can help please.

My hosting company have identified some spikes in MySQL usage relating to your plugin.

On doing some research it looks like enabling Turbo Mode might be the answer I need.

We have quite a large product data set. About 3000 products but about 120,000 variations.

It seems to reach the limit of 15,000.  Is that correct it should count variations too? We only need you to sort by products as the way we are using the plugin as it's on product tags.

Is there a way to tell your plugin only to look at products (not variations) to speed it up?

I found this:

https://products-filter.com/turbo-mode

So should I just increase the 15,000 to say 150,000 here in /wp-content/plugins\woocommerce-products-filter\ext\turbo_mode\index.php :

 

$start += $step;
$limit = apply_filters("woof_turbo_mode_products_limit", 15000);
if ($start > $limit) { // limiting the number of products
$do = false;
}
Will this speed it up or slow it down?
We don't have 'weak' hosting. It's WP Engine and they are very good and also using their caching + nitropack but we do have a large number of variations.
Thank you
Joel
#1
Pablo Borysenco(@pavlo_borysenco)
34,196 Posts
March 6, 2023, 14:00

Hello Joel

Is there a way to tell your plugin only to look at products (not variations) to speed it up? - Yes, but then the filtering will not be correct

So should I just increase the 15,000 to say 150,000 here in   - Yes, so that the filter creates a complete list of products (use  hook)

Will this speed it up or slow it down? - In this case, I don't think it will make filtering faster.

#2
Joel(@joel-2)
2 PostsTopic Author
Customers
March 6, 2023, 19:28

That's great, thank you.

 

We will edit the hoook.

I realise I asked the wrong question! The speed of your filter is fine. What I want to know is if using Turbo mode and editing the hook like this will reduce the MySQL use and the spikes we are seeing in the database use from your plugin.

I guess we will try it!

 

Thank you

Joel

#3
Pablo Borysenco(@pavlo_borysenco)
34,196 Posts
March 7, 2023, 12:08

Hello Joel

The whole point of this option is to remove the load from the server. Yes, this will greatly reduce the number of MySQL queries.  But perhaps in your case the filter will start to work more slowly.

 

#4