[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:  Future
                                                 |  Release
Component:  Database                             |     Version:  3.0.1
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch dev-feedback 4.1-early     |     Focuses:
  commit                                         |  performance
-------------------------------------------------+-------------------------
Changes (by SergeyBiryukov):

 * keywords:  has-patch dev-feedback 4.1-early commit bulk-reopened => has-
     patch dev-feedback 4.1-early commit
 * owner:  (none) => SergeyBiryukov
 * status:  new => reviewing


Comment:

 Replying to comment:7:
 > I didn't catch that get_lastpostmodified() also calls
 get_lastpostdate(), triggering the other query. Lame.

 Introduced in [952].

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