Support » Plugin: WooCommerce » Woocommerce slow query

  • Hi, my on my store I’m using Query Monitor and on product pages it shows over 100 slow queries. And because of that my load time are over 30 seconds or more. I asked my hosting provider (A2 Hosting) about it and they confirmed that there is no problem on their side and this may be plugin problem. The queries that are slow looks like this:

    SELECT t.*, tt.*
    FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt
    ON t.term_id = tt.term_id
    INNER JOIN wp_term_relationships AS tr
    ON tr.term_taxonomy_id = tt.term_taxonomy_id
    WHERE tt.taxonomy IN (‘product_shipping_class’)
    AND tr.object_id IN (878)
    ORDER BY t.name ASC

    and

    SELECT DISTINCT t.*, tt.*, tm.meta_value
    FROM wp_terms AS t
    INNER JOIN wp_term_taxonomy AS tt
    ON t.term_id = tt.term_id
    INNER JOIN wp_term_relationships AS tr
    ON tr.term_taxonomy_id = tt.term_taxonomy_id
    LEFT JOIN wp_termmeta AS tm
    ON (t.term_id = tm.term_id
    AND tm.meta_key = ‘order’)
    WHERE tt.taxonomy IN (‘product_cat’)
    AND tr.object_id IN (828)
    ORDER BY tm.meta_value+0 ASC, t.name ASC

    and both are called by:
    WP_Term_Query->get_terms()
    wp-includes/class-wp-term-query.php:695

    I’m adding some images maybe it helps:

    http://prntscr.com/fnxujj
    http://prntscr.com/fnxuv0
    http://prntscr.com/fnxvne
    http://prntscr.com/fnxvxc
    http://prntscr.com/fnxz57
    http://prntscr.com/fnxzbd

    WordPress version: 4.8
    Woocommerce version: 3.0.9
    Active plugins: 19
    Products: 55
    PHP version: 7.0
    Server cores: 2 x 2.1Ghz
    RAM: 1 GB
    Theme: Flatsome

    Maybe anyone had similar problem and know any possible solution to fix it. This is the first time when I ask something so if anyone needs any more information I will try to provide it.

Viewing 1 replies (of 1 total)
  • Too many plugins to think that they are really all useful.

    Not enough RAM on the server.

    Is you shop still slow with Storefront theme ?

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