[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 OllieJones):

 This looks good to me. About the bulk-update slowdown objection, bulk
 updates are very rare compared to page views, and aren't generally a good
 reason to avoid otherwise useful indexes.

 I think it's a good idea to make these new index names follow the
 convention in others, where column names appear in the index names.
 There's zero penalty for long index names.



 {{{
  KEY type_status_post_date_gmt (post_type,post_status,post_date_gmt)
  KEY type_status_modified_date_gmt
 (post_type,post_status,post_modified_gmt)
 }}}

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