[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
-------------------------------------------------+-------------------------
Changes (by archon810):

 * focuses:   => performance


Comment:

 #31171 is indeed a duplicate, but the proposed solution there is far more
 optimized than the one in this ticket because it ends up with `Using
 where; Using index` and a much shorter table scan.

 Please consider the index in #31171.

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