• Right after upgrading to 2.6.1, I’ve received following slow SQL queries, can anyone advise ‘how do I optimize these queries?’

    ### 2 Queries
    ### Total time: 4, Average time: 2
    ### Taking 2 , 2 seconds to complete
    ### Rows analyzed 21555 and 21555
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE XXX=XXX AND
    wp_posts.post_type = 'XXX' AND (wp_posts.post_status = 'XXX') ORDER BY
    wp_posts.post_date DESC LIMIT XXX, XXX;
    
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 7, 10;
    
    ### 1 Query
    ### Total time: 2, Average time: 2
    ### Taking 2 seconds to complete
    ### Rows analyzed 11791
    use dbXXX_wp;
    SELECT p.* FROM wp_posts AS p WHERE p.post_date > 'XXX' AND p.post_type = 'XXX' AND p.post_status = 'XXX' ORDER BY p.post_date ASC LIMIT XXX;
    
    use db46425_wp;
    SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2007-09-24 16:12:50' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1;
  • The topic ‘2.6.1 added slow SQL queries’ is closed to new replies.