Heavy query slows down every backend site

  • thoenidesign

    (@thoenidesign)


    1 month ago

    Dear support

    We are experience a very slow backend, no matter which site the backend user is loading.
    After investigating we realized that the main cause is a very expensive query which takes at least 5x longer than the second slowest query, often even 10-20x longer (see query monitor plugin).
    This query does seem unnecessary on almost all pages and is probably just needed on TI Wishlist backend pages.

    The Query:
    SELECT SUM(count) as stats_count
    FROM (SELECT COUNT(B.ID) AS count
    FROM wp_tinvwl_analytics AS A
    LEFT JOIN wp_tinvwl_items AS C
    ON C.wishlist_id = A.wishlist_id
    AND C.product_id = A.product_id
    AND C.variation_id = A.variation_id
    LEFT JOIN wp_tinvwl_lists AS B
    ON C.wishlist_id = B.ID
    LEFT JOIN wp_tinvwl_lists AS G
    ON C.wishlist_id = G.ID
    AND G.author = 0
    WHERE A.product_id > 0
    GROUP BY A.product_id, A.variation_id
    HAVING count > 0
    LIMIT 0, 9999999) AS A

    Caller:
    TInvWL_Public_AddToWishlist->set_wishlists_data_cookies()

    Plugin:
    ti-woocommerce-wishlist-premium

    Can you please fix the code so that queries are only triggered when really needed?
    Thanks!

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter thoenidesign

    (@thoenidesign)

    Hi there

    Unfortunately this issue is still affecting the site heavily and could not hear back from you yet but paying for a premium license. Can you check out the bug or give us some guidance, how we could fix the issue ourself?

    Thank you in advantage!

    Thread Starter thoenidesign

    (@thoenidesign)

    Hi there
    Is this plugin still maintained or do you just sell premium license for a broken product with no support?

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