[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:
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Future
Component:  Database                             |  Release
 Severity:  normal                               |     Version:  3.0.1
 Keywords:  has-patch dev-feedback 4.1-early     |  Resolution:
  commit                                         |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by Denis-de-Bernardy):

 It's the case if a cursory search is anything to go by.

 `get_lastpostmodified()` is used once in each feed template file over in
 wp-include, and another time in the wp-include/class-wp.php to create an
 ETag for post feeds.

 `get_lastcommentmodified()` gets an identical treatment.

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