[wp-trac] [WordPress Trac] #7876: post_parent needs an index

[WordPress Trac]

#7876: post_parent needs an index
--------------------------+-------------------------------------------------
 Reporter:  Otto42        |       Owner:  anonymous
     Type:  defect        |      Status:  new      
 Priority:  normal        |   Milestone:  2.7      
Component:  Optimization  |     Version:           
 Severity:  normal        |    Keywords:           
--------------------------+-------------------------------------------------
 Lots of the new functionality related to attachments and galleries and
 such causes queries which use the post_parent field in the posts table.
 This field is not indexed, meaning that queries for the images in a
 gallery cause a lot of DB work to be done. Indexing this field would
 reduce this work quite a bit, and speed up the creation of gallery
 displays in posts.

 Suggest we add a new index on post_parent to the schema.

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