[wp-trac] [WordPress Trac] #15499: Add an index for get_lastpostmodified query

[WordPress Trac]

#15499: Add an index for get_lastpostmodified query
------------------------------------+-----------------------------
 Reporter:  simonwheatley           |       Owner:  SergeyBiryukov
     Type:  enhancement             |      Status:  reviewing
 Priority:  normal                  |   Milestone:  6.2
Component:  Database                |     Version:  3.0.1
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |     Focuses:  performance
------------------------------------+-----------------------------

Comment (by mukesh27):

 Thanks @rjasdfiii for the info. So you are suggesting to use single INDEX
 instead of two?


 `INDEX(post_status, post_type, post_modified_gmt, post_date_gmt)`

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