Support » Plugin: WOOF - Products Filter for WooCommerce » Your Demo Site is very slow (37s page load)

  • Hi,
    I really like your plugin and it has a lot of great features but recently, I had big performance problems. I read your tips about performance and tried them, but they did not really worked for me. So I tried you demo website with 10k products and experienced similar issues. Setting some filters I ended up with a TTFB of 37 seconds (TTFB: Time after the last header of the request was send and just before the first byte of the response was received). This is only true for the first request with these settings. The second is much faster. Ff you change one parameter (e.g. price) it is slow again.

    Filtersettings and Timing diagram can be found here: https://ibb.co/s1pLdmY

    Anyway, on my localhost I have about 50k products and it takes 22s to load a category page with WOOF switched on. Without WOOF it takes 2,4s. (recount disabled, cache terms activated). I optimized my database but there was no change to that. It’s too slow for me.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support mediawebster

    (@mediawebster)

    Hello

    recount disabled – In this case, the filter should load quickly.
    How many taxonomies do you have?

    Hi,
    thank you for your quick reply. I have just a few taxonomies (8) but a lot of taxonomy terms. But those taxonomies with a lot of terms are not used for user defined filtering. On my local host I disabled recount and enabled cashing for term. I also tried to delete all filters but there was no significant improvement in speed. I only see a significant change in speed when I disable the plugin.

    Plugin Support mediawebster

    (@mediawebster)

    Hello

    Please drop me exact link to the issue

    Do test as log-out user

    Hi,
    I did not publish a website with so many products yet. If it helps I publish a demo version but it is probably the same issue that makes your demo website with 10k products loads for 30s when you click e.g. this link for the first time: https://demo10k.products-filter.com/?swoof=1&min_price=4&max_price=67&stock=instock (simply change the price range for and it will again load for 30s)

    I searched for slow db queries with this plugin and found out that 2 queries take most of the time. It takes 8 seconds to get the minimum price and another 8 seconds to get the maximum price. Details

    Hope this helps to replicate the behavior. if not I will set up a demo page.

    • This reply was modified 2 weeks, 2 days ago by vito92.
    Plugin Support mediawebster

    (@mediawebster)

    Hello
    You can try set min max price in code – \wp-content\plugins\woocommerce-products-filter\classes\helper.php
    add code – https://c2n.me/48dD3eE.png AND https://c2n.me/48dD5ao.png

    Thank’s for the tip. I resolved this problem by disabling your price filter and enabling the standard price filter of woocommerce. Instead of 2×8 seconds it gets min and max price in one query in 0.5 seconds. It seems that in my case their query is much more efficient. Maybe their query could be an inspiration for a performance update of your plugin? query
    Anyway, I have to say your support is absolutely great. Fast reply and good ideas! Thank you!

    • This reply was modified 1 week, 6 days ago by vito92.
    Plugin Support mediawebster

    (@mediawebster)

    Hello
    Great! Welcome;)

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.