Slow Query
-
We are been using your plugin for ages and bought, the news plugin too, but now one of your queries is killing us, we are using 3.4 version of your plugin, the query is:
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND wp_posts.ID NOT IN (213208)
AND ( wp_postmeta.meta_key = ‘_yoast_wpseo_focuskw’ )
AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’)
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘future’
OR wp_posts.post_status = ‘draft’
OR wp_posts.post_status = ‘pending’
OR wp_posts.post_author = 3
AND wp_posts.post_status = ‘private’)
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 2It takes 14 seconds or more, when we try to create a new post, can you take a look at least,
Thank′s very much in advanced
- The topic ‘Slow Query’ is closed to new replies.
