[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:  3.5
Component:  Database                |     Version:  3.0.1
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |
------------------------------------+--------------------

Comment (by nacin):

 I recall barry hesitating for the idea of adding an index to improve a
 single query.

 This query is persistently cached, so this is definitely less of a concern
 than if we couldn't reasonably cache it.

 get_lastpostmodified() is only used in core with 'GMT' (and only for
 feeds), so I think at most we need to add type_status_modified.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15499#comment:5>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software