[wp-trac] [WordPress Trac] #18120: Slow SQL in get_adjacent_post()

[WordPress Trac]

#18120: Slow SQL in get_adjacent_post()
--------------------------+------------------------------
 Reporter:  javert03      |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Query         |     Version:  3.2.1
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |
--------------------------+------------------------------

Comment (by arpit.tambi.in):

 I am having this exact same problem, I have over 20 million custom posts
 in wp_posts table and this query takes over 30 seconds to execute.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/18120#comment:2>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software