[wp-trac] [WordPress Trac] #42369: Thousands of pages slow down dashbord page add

[WordPress Trac]

#42369: Thousands of pages slow down dashbord page add
-----------------------------+-----------------------------
 Reporter:  C3dRy2K          |      Owner:
     Type:  feature request  |     Status:  new
 Priority:  normal           |  Milestone:  Awaiting Review
Component:  Administration   |    Version:  4.8.2
 Severity:  normal           |   Keywords:
  Focuses:  performance      |
-----------------------------+-----------------------------
 I have a website with around ~ 50k pages (post_type page) and when
 accessing the dashboard to add another one, the dashboard add new page
 loads in ~ 20s.

 The heavy loading comes from Parent attribute section, where wp has to
 generate a insane select form tag. Couldn't we refactor this part to use a
 jquery autocomplete, like on non hierarchical taxonomy?

 Also, the SQL query is "SELECT * FROM wp_posts ..." when as far I can see,
 we only need "SELECT ID, post_title FROM wp_posts ...", Time: 12.506s
 compare to Time: 0.507s for second query.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/42369>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform