[wp-trac] [WordPress Trac] #41714: wp_list_pages() - horrible performance due to eventual "SELECT *"

[WordPress Trac]

#41714: wp_list_pages() - horrible performance due to eventual "SELECT *"
-------------------------------+------------------------------
 Reporter:  DavidAnderson      |       Owner:  (none)
     Type:  defect (bug)       |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Posts, Post Types  |     Version:  4.9
 Severity:  normal             |  Resolution:
 Keywords:                     |     Focuses:
-------------------------------+------------------------------

Comment (by arena):

 Have you tried just adding an index on post table

 {{{
 CREATE INDEX `wp_list_pages`
 ON `**db**`.`**prefix**_posts`
 (post_type,
 post_status,
 post_date ASC)
 }}}

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/41714#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform