Date Queries

  • Dennis Whiteman

    (@fastpipe)


    13 years, 6 months 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

  • The topic ‘Date Queries’ is closed to new replies.