post_parent needs an index
|Reported by:||Otto42||Owned by:||anonymous|
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.