Compound indexes

[scribu]

Instead of having an index on just the p2p_type column, we could potentially get better performance by having two compound indexes:

(p2p_type, p2p_from)
(p2p_type, p2p_to)

http://wordpress.org/support/topic/plugin-posts-2-posts-use-of-compound-indexes

[judgej]

On my 15,000 linked posts, doing this shaves very approximately about 5mS off a 40mS query. With more connection types, it could improve things more.

The 40mS query gets the track listings here, for example:

http://www.soulbrother.com/shop/newbannewban-2/