SQL_CALC_FOUND_ROWS

  • damiandiaz

    (@damiandiaz)


    1 month, 4 weeks ago

    Upon reviewing the database with a query monitor, we found that there are
    slow queries coming from the woocommerce-ajax-filters plugin. The plugin
    is attempting to calculate dynamic pricing rules for every single item in
    the WordPress loop.

    Additionally, the query running from the woocommerce-ajax-filters plugin
    starts with a SELECT SQL_CALC_FOUND_ROWS statement. This forces
    pagination when running the query, as it must find and count every single
    matching product before serving the first 40 results. Combined with heavy
    JOIN queries, this is heavily impacting the performance of the website.
    You can see a screenshot of all the rules the database queries are
    running at the following link:

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

Viewing 1 replies (of 1 total)
  • Plugin Author RazyRx

    (@razyrx)

    1 month, 3 weeks ago

    Hello,

    It is main query from WooCommerce and it is use WordPress WP_Query functionality to build query.
    Plugin do not modify how it work to make it more compatible with most themes and other plugins.

    Plugin has multiple settings that can slow down page load and you can change it if you do not need it:
    – Set option Values count and output; to All non-empty values are displayed; standard recounting is applied, but it will disable any recounting after filtering.
    If you have value All empty values are removed based on page (categories/tags/ etc.); filters are applied in recounting attribute values; all empty values based on applied filters will be hidden then change it to latest value that works similar but faster Filters are applied in recounting attribute values; empty values are removed on the server-side
    – Set option Hide out of stock variations(Plugin settings -> General tab) to Disabled if you do not have variations or do not need variations search.
    – Disable Search variation price(Plugin settings -> General tab) if you do not need search price of variations.

    Regards,
    Oleg

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.