Date Queries (1 post)

  1. Dennis Whiteman
    Posted 5 years ago #

    We are getting crushed this morning with some unusual queries based on post date that seem to be taking a long time:

    # Time: 101018 13:04:15
    # Query_time: 40 Lock_time: 0 Rows_sent: 1 Rows_examined: 15792
    SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2006-09-12 00:00:00' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1;

    Does anyone know what might be searching for a range of dates without an upper limit?



Topic Closed

This topic has been closed to new replies.

About this Topic

  • RSS feed for this topic
  • Started 5 years ago by Dennis Whiteman
  • This topic is not resolved
  • WordPress version: 3.0.1