[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 3.6-early  |  Resolution:
----------------------------------------------+----------------------------

Comment (by brokentone):

 The great majority of the time these functions are called are within a
 feed context, and in fact, they're called multiple times there. Once, in
 the WP::send_headers() then once for the feed generation. I'm not sure if
 this query is caching within WP or mysql at all and thus whether the
 second call is significant, but I would expect it is significant.

 I'm looking to remove the first call, and set the headers later in #22742.
 If there are hesitations to adding the index, then perhaps reducing the
 query by 1/2 would be another way to deal with this issue. (Although,
 without a full investigation, I like the index).

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