[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:  4.0
Component:  Database                                 |     Version:  3.0.1
 Severity:  normal                                   |  Resolution:
 Keywords:  has-patch dev-feedback 3.6-early commit  |     Focuses:
-----------------------------------------------------+--------------------
Changes (by DrewAPicture):

 * keywords:  has-patch dev-feedback 3.6-early => has-patch dev-feedback
     3.6-early commit


Comment:

 Replying to [comment:7 nacin]:
 > Here's the thing. I don't know why. `get_lastpostdate()` wants to know
 the newest published post. Since it's published, it can't be in the
 future. `get_lastpostmodified()` wants to know the latest modified date.
 There is never going to be a situation that I can think of (aside from
 manually messing around with the values) where the latest post_modified
 date in a table is going to be less than the latest post_date in a table.
 >
 > I think we can just axe the call to `get_lastpostdate()` from
 `get_lastpostmodified()` for the same amount of functionality.

 Seems logical. [attachment:15499.diff] still applies cleanly.

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