HUSKY - WooCommerce Products Filter Professional

A lot of cheap hosting companies provide their services with weak hardware. Because of this, product searching may be slow. You can do the following steps:

• Use cache plugins, for example this one
• Switch off ‘dynamic recount‘ in the filter and ‘hide empty terms‘ options
• Use Autoptimize
• Add more memory to your WordPress site
• Use PHP 8.x.x
• Also in tab Advanced → Options, try to activate ‘Cache dynamic recount number for each item in filter‘ OR ‘Cache terms‘ if your search form has a lot of terms
• In tab Advanced → Options, enable ‘Optimize price filter‘ to reduce server load
• Add database indexes to improve query performance (run in phpMyAdmin):

  ALTER TABLE wp_postmeta ADD INDEX woof_meta_key_value (meta_key(191), meta_value(20));
  ALTER TABLE wp_posts ADD INDEX woof_type_status (post_type(20), post_status(20));

  Note: Replace wp_ with your actual table prefix if different.

• You can also hide the search form entirely and show it on demand. In the widget set ‘Yes‘ to ‘Hide search form by default and show one button instead‘, in shortcode [woof] use attribute ‘start_filtering_btn‘

+ You can use links of pages and masks (Ex.: product-category) where WOOF functionality should be initialized: tab Advanced → Init plugin on the next site pages only – this will prevent initialization of the plugin functionality on all pages of the site
Also read:

• woof_counter_method
• woof_use_wp_cache

I must say, that is some pretty decent support 🙂
I also might have found something nice you might like: I’ve emailed you before about slow queries made by the plugin. The plugin’s queries are still huge but I understand it’s a WordPress (WooCommerce variations) thing. I found a solution though to avoid long loading times: tweaking MySQL by using this gimmick: http://mysqltuner.com/
Loading times went from 15 sec. to 4/5 sec. now. Still not fast but way better than before. Next step is upgrading PHP since I’m running 5.3.
Anyway: if people complain about woof making things slow, try to hint them on the mysqltuner. It made a big difference for me.
Thanks again!
Bart