Slow Query
-
we have 2 queries that are killing us!, each one is running 2 or 3 times, every minute and causing performance issues
SELECT meta_key FROM wp_postmeta\n\t\t\t\tGROUP BY meta_key\n\t\t\t\tHAVING meta_key NOT LIKE ‘\\_%’ and meta_key NOT LIKE ‘field_%’\n\t\t\t\tORDER BY meta_key\n\t\t\t\tLIMIT 150
This first we believe is a meta box in the edit post page
SELECT ID, post_content, post_name, post_author, post_parent, post_date_gmt, post_date, post_date_gmt, post_title, post_type\n\t\t\t FROM wp_posts\n\t\t\t WHERE post_status=’publish’\n\t\t\t AND (DATEDIFF(CURDATE(), post_date_gmt)<=2)\n\t\t\t AND post_type IN (‘post’,’page’)\n\t\t\t ORDER BY post_date_gmt DESC\n\t\t\t LIMIT 0, 1\n\t\t
the second one, we don’t know where
Can any one help us??
- The topic ‘Slow Query’ is closed to new replies.