wcv-comissions page loads slow (+180 sec)

  • After upgrading to 2.5.0.1 this page is very slow.

    Query monitor points to this wcv_get_product_total_sales_by_order_status() (class-functions.php). This query takes more than 180 secs.

    I have made indexes for all relevant columns with little to no impact on the query time.

    The woocommerce_order_items has 2761355 rows and the woocommerce_order_itemmeta has 22858685 rows.

    Please help as our many users are suffering.

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

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @runeneve ,

    I’m sorry to know about the long database query time.

    I tried to see whether wcv_get_product_total_sales_by_order_status() would take much time on my test site, but it didn’t.

    See: https://share.zight.com/2Nu8ByrA

    Let’s first make sure the delay is not from another active plugin’s queries.

    Kindly:

    1. Deactivate all plugins except:

      • WooCommerce,
      • WC Vendors Marketplace, and
      • WC Vendors Pro,

      2. Visit WC Vendors > Commissions to see whether the load (query execution) time decreases.

        If that doesn’t help, there’s a chance that it could be with the server disc usage. Kindly check with your web hosting provider to confirm that.

        I look forward to getting this resolved for you.

        Thread Starter runeneve

        (@runeneve)

        Hi Israel.

        Thank you for your reply.

        Tried deactivating modules and checked my hosts memory and storage.

        The load time is the same. Is the problem here that the plugin is not designed for the size of database we are running? Or do you have any other suggestions?

        I also tried to copy the SQL from query monitor and execute that in phpmyadmin. The query is still slow but a little better (+150 secs).

      Viewing 2 replies - 1 through 2 (of 2 total)
      • The topic ‘wcv-comissions page loads slow (+180 sec)’ is closed to new replies.