• Hello,

    After updating wordpress, website takes 10-12 second to fully load, as i checked these are the queries which are taking all the time to load. I checked and created index as well. but nothing is working for now. Please guide me for the solution.

    One all them is this and rest are same with different filters in WHERE

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
    FROM wp_posts
    INNER JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    INNER JOIN wp_postmeta AS mt1
    ON ( wp_posts.ID = mt1.post_id )
    INNER JOIN wp_postmeta AS mt2
    ON ( wp_posts.ID = mt2.post_id )
    INNER JOIN wp_postmeta AS mt3
    ON ( wp_posts.ID = mt3.post_id )
    WHERE 1=1
    AND ( wp_postmeta.meta_key = 'start_date'
    AND ( ( mt1.meta_key = 'end_date'
    AND mt1.meta_value > '20210827' )
    OR ( ( mt2.meta_key = 'end_date'
    AND mt2.meta_value = '20210827' )
    AND ( mt3.meta_key = 'end_time'
    AND mt3.meta_value > '05:25:08' ) ) ) )
    AND wp_posts.post_type = 'events'
    AND (wp_posts.post_status = 'publish'
    OR wp_posts.post_status = 'acf-disabled'
    OR wp_posts.post_status = 'private')
    GROUP BY wp_posts.ID
    ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC, wp_posts.post_date DESC
    LIMIT 0, 2

    Regards
    Rajat Sharma

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘DB Slow down after WordPress Update’ is closed to new replies.