[wp-trac] [WordPress Trac] #19225: WordPress-Importer : Perform less database queries when backfilling attachment urls

WordPress Trac wp-trac at lists.automattic.com
Thu Nov 10 12:36:42 UTC 2011


#19225: WordPress-Importer : Perform less database queries when backfilling
attachment urls
-------------------------+-------------------------------------
 Reporter:  tott         |      Owner:
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Import       |    Version:
 Severity:  normal       |   Keywords:  has-patch needs-testing
-------------------------+-------------------------------------
 The current backfill_attachment_urls() approach causes a REPLACE query for
 each attachment url. This can cause the invalidation of a lot of data and
 also cause MySQL replication lag in some cases.

 The attached patch will make sure to bundle these requests and perform
 only maximum of one db update per post.

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


More information about the wp-trac mailing list