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

WOOF filtering (queries) extremely slow with 'variations in stock check'

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.
saypontigohe(@saypontigohe)
8 Posts
Customers
October 17, 2022, 19:35

Hi! I am running Woof products filter on a powerful VPS, with around 1.000 products (24 max per page) with each product around 3-5 variations on average (size from XS to XL). I use the 'in stock' extension, and it is extremely slow, where loading times take up to 25 seconds, even if there is only one product available.

Redis caching & main caching (WP Rocket) are enabled.  It makes the initial pages a lot faster, but does not impact the filtering itself. This has to be something wrong in the way the quering goes, since I have never seen anything the like.

Any help really appreciated!

#1
Pablo Borysenco(@pavlo_borysenco)
34,196 Posts
October 18, 2022, 11:33

Hello

What plugin version number are you using?

#2
saypontigohe(@saypontigohe)
8 PostsTopic Author
Customers
October 18, 2022, 11:49

Hi! I am using 2.7.7. However, I fixed some things by tweaking the caching in the plugin, server and using Turbo.  I still find some issues, but I first want to make sure they are not on my side.

In short for other people reading this post; Don't forget there are caching settings in the plugin itself as well. And the dynamic recount takes up A LOT of resources, because (logically) it has to run through all products to check if any variation still has stock. A very heavy query.

Thanks for the fast response Pablo! Wanted to be first to give an update, but was just ready with it. Now we have to check what goes 'wrong' with Turbo mode on our side.

#3
Pablo Borysenco(@pavlo_borysenco)
34,196 Posts
October 18, 2022, 12:09

Please paste your license key here - https://share.pluginus.net/image/i20210618130558.png -> https://share.pluginus.net/image/i20210618130614.png

Update  the  plugin  to latest  version - https://products-filter.com/how-to-make-auto-update-for-wordpress-plugins-and-themes-bought-on-envato

#4