[wp-trac] [WordPress Trac] #10911: Optimize scan for lost attachments

[WordPress Trac]

#10911: Optimize scan for lost attachments
------------------------------+---------------------------------------------
 Reporter:  johnjosephbachir  |       Owner:       
     Type:  enhancement       |      Status:  new  
 Priority:  normal            |   Milestone:  2.8.5
Component:  Optimization      |     Version:  2.8.4
 Severity:  normal            |    Keywords:       
------------------------------+---------------------------------------------
 This patch moves all of the logic for scanning for lost attachments to the
 DB.

 The code is more simple, and from my simple but repeated tests, the
 performance is significantly improved (done against a pretty sizeable
 posts table).

 We could do it in one query instead of two if !WordPress required MySQL
 4.1, but subqeuries are not supported in 4.0 so we have to do it in two.

 The patch was made against trunk, revision 11997 (last change to
 update.php, 11013)

 Let me know if you have any questions or suggestions.

 John

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10911>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software