[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:  Awaiting Review
Component:  Database      |     Version:  trunk
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+------------------------------

Comment (by ComputerGuru):

 For reference, I also filed an enhancement request upstream with MariaDB
 to explore the possibility of automating this transform in the query
 optimizer: https://jira.mariadb.org/browse/MDEV-14635

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