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

 An index to improve a single query is fine, if that query is run
 frequently enough.

 I don't think using the object cache is a good enough reason to not do
 this - do that many sites really have a persistent cache? Similarly, I
 think these indexes would be more helpful on self-hosted sites than they
 would be harmful on WP.com.

 I'm not following why we'd do one but not the other - both queries are run
 every time get_lastpostmodified() is called.

 Finally, nobody likes long read locks. :)

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