2 queries causing bottleneck

Last updated on by

Home › Forums › Legacy Support › Support queries › Update Issues › 2 queries causing bottleneck

Tagged: 

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • September 26, 2020 at 1:18 am #314051
    hilmanf
    Spectator
    Hi! My site is experiencing heavy lagging caused by these 2 queries below: 1st query: SELECT sx5p1B_comments.comment_ID FROM sx5p1B_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 30920 AND user_id = 107563 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY sx5p1B_comments.comment_date_gmt DESC LIMIT 0,1 2nd query: SELECT count(p.ID) FROM sx5p1B_posts as p LEFT JOIN sx5p1B_postmeta as pm ON pm.post_id = p.ID WHERE pm.meta_key = 1 and p.post_status = 'publish' and p.post_type = 'course'

    1. What queries is that?

    2. How to optimize the 2 queries?

    September 26, 2020 at 1:21 am #314052
    hilmanf
    Spectator
    This reply has been marked as private.
    September 26, 2020 at 2:35 pm #314244
    Anshuman Sahu
    Keymaster
    1 . "webhook_delivery" this is not our theme or plugin query , this is some other plugin related . 2 . the second query is to get the course count in my courses tab you see : https://prnt.sc/uobcye this is a very small query with one join only .
    September 26, 2020 at 4:54 pm #314275
    hilmanf
    Spectator
    This reply has been marked as private.
    September 28, 2020 at 12:12 pm #314524
    Anshuman Sahu
    Keymaster
    Yup "webhook_delivery" seems to be related with that.Wplms or any of its plugins does not makes any queries related with webhook_delivery ? this seems to be woocommerce internal error .
  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • The topic ‘2 queries causing bottleneck’ is closed to new replies.