Slow queries

  • Resolved so5djo

    (@so5djo)


    8 months, 3 weeks ago

    Hello,

    In query monitor we see a lot of queries from woocommerce plugin, which is slowing our site. Sending caller:

    1. WC_Widget_Price_Filter->get_filtered_price()
      wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-price-filter.php:184
    2. WC_Widget_Price_Filter->widget()
      wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-price-filter.php:90
    3. WP_Widget->display_callback()
      wp-includes/class-wp-widget.php:394
    4. dynamic_sidebar('sidebar-shop')
      wp-includes/widgets.php:837
    5. load_template('wp-content/themes/woodmart/sidebar.php')
      wp-includes/template.php:790
    6. locate_template()
      wp-includes/template.php:725
    7. get_sidebar('shop')
      wp-includes/general-template.php:136
    8. wc_get_template()
      wp-content/plugins/woocommerce/includes/wc-core-functions.php:345
    9. woocommerce_get_sidebar()
      wp-content/plugins/woocommerce/includes/wc-template-functions.php:1051
    10. do_action('woocommerce_sidebar')
      wp-includes/plugin.php:517
    11. wc_get_template()
      wp-content/plugins/woocommerce/includes/wc-core-functions.php:345

    Please for help and any suggestion how to fix this, I would appreciate.

    Best regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello so5djo

    Thank you for contacting WooCommerce support.

    I understand you are having an issue with your website performance.

    The queries you have mentioned are core queries and are required for WooCommerce to function properly.

    To help you further, I’d like to understand more about your setup.
    Could you please send me a copy of your site’s System Status Report?
    You can find it via WooCommerce > Status.
    Select Get system report and then Copy for support.

    Once you’ve done that, you can paste the text in https://gist.github.com
    After that, you can paste the Gist link here in your reply.

    This report will help me understand your WordPress environment and provide insights about how to improve the overall website performance.

    Looking forward to your response. ??

    Thread Starter so5djo

    (@so5djo)

    Hello @doublezed2,

    Thank you for your reply. That is correct, we are having slower performance of filters.

    Here is the required report: https://gist.github.com/djordjevicsonja/59367b45153d6b799051f44de8be84f3

    Looking forward to your reply.

    Regards

    Plugin Support Shameem a11n

    (@shameemreza)

    Hi @so5djo,

    The queries you’re seeing are related to the Price Filter widget. This widget is used to filter products based on price range, and it’s designed to work in real time, which can result in a high number of queries. If you have many products (I can see you currently have 6555 products), it could slow down your site loading as the widget will look at all the products’ prices.

    If you’re not actively using the Price Filter widget, I suggest removing it from your sidebar. This should reduce the number of queries and potentially speed up your site.

    If you need the Price Filter widget, you might need to consider using a caching or other product filtering plugin like Product Filters for WooCommerce or HUSKY. This could help to reduce the number of queries being made by storing the results of previous queries and reusing them when possible.

    I hope this provides some clarity. Please let us know if you have any other questions!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Slow queries’ is closed to new replies.