WordPress.org

Ready to get started?Download WordPress

Forums

Date Queries (1 post)

  1. Dennis Whiteman
    Member
    Posted 3 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?

    Thanks,

    Dennis

Topic Closed

This topic has been closed to new replies.

About this Topic

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