[wp-trac] [WordPress Trac] #42883: Use sargable queries for date-based lookups for posts

[WordPress Trac]

#42883: Use sargable queries for date-based lookups for posts
----------------------------------------+-----------------------------
 Reporter:  ComputerGuru                |       Owner:
     Type:  enhancement                 |      Status:  new
 Priority:  normal                      |   Milestone:  Future Release
Component:  Query                       |     Version:  3.7
 Severity:  normal                      |  Resolution:
 Keywords:  needs-patch good-first-bug  |     Focuses:  performance
----------------------------------------+-----------------------------
Changes (by boonebgorges):

 * keywords:   => needs-patch good-first-bug
 * version:  trunk => 3.7
 * component:  Database => Query
 * milestone:  Awaiting Review => Future Release


Comment:

 Hi @ComputerGuru - Thanks very much for the detailed post. This sounds
 like an excellent enhancement.

 Writing this patch will be a medium-sized but self-contained project,
 probably appropriate for a new contributor. (Specifically, the person
 writing the enhancement will have to be careful when calculating "end"
 dates, especially for months.) Our existing test coverage for date queries
 is probably good enough to cover the changes described here; see
 https://core.trac.wordpress.org/browser/tags/4.9.1/tests/phpunit/tests/date/query.php
 and
 https://core.trac.wordpress.org/browser/tags/4.9.1/tests/phpunit/tests/query/date.php

--
Ticket URL: <https://core.trac.wordpress.org/ticket/42883#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform