Title: 2.6.1 added slow SQL queries
Last modified: August 19, 2016

---

# 2.6.1 added slow SQL queries

 *  [Rok](https://wordpress.org/support/users/rok/)
 * (@rok)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/261-added-slow-sql-queries/)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Rok](https://wordpress.org/support/users/rok/)
 * Last activity: [17 years, 8 months ago](https://wordpress.org/support/topic/261-added-slow-sql-queries/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics