[wp-trac] Re: [WordPress Trac] #5649: to_ping query optimization

[WordPress Trac]

#5649: to_ping query optimization
-------------------------------------------------+--------------------------
 Reporter:  misterbisson                         |        Owner:  westi 
     Type:  defect                               |       Status:  closed
 Priority:  normal                               |    Milestone:  2.5   
Component:  Optimization                         |      Version:  2.3.2 
 Severity:  normal                               |   Resolution:  fixed 
 Keywords:  to_ping, mysql, query, optimization  |  
-------------------------------------------------+--------------------------
Comment (by lloydbudd):

 For reference: Andy Skelton asking him to submit the above patch, from
 [wp-hackers] to_ping query optimization

 Hey Casey! Your query looks great to my eyes. I would guess that the
 existing code was written to avoid selecting rows full of spaces or
 shorter than 'http://' (7 chars). It would be more efficient to a) use
 your query, and b) make sure the field is empty when all valid pings
 have been sent.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/5649#comment:4>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software