WordPress.org

Make WordPress Core

Opened 4 years ago

Closed 4 years ago

#42369 closed feature request (duplicate)

Thousands of pages slow down dashbord page add

Reported by: C3dRy2K Owned by:
Milestone: Priority: normal
Severity: normal Version: 4.8.2
Component: Posts, Post Types Keywords: dev-feedback
Focuses: performance Cc:

Description

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.

Change History (3)

#1 @rinkuyadav999
4 years ago

  • Component changed from Administration to Bootstrap/Load

#2 @rinkuyadav999
4 years ago

  • Keywords dev-feedback added

#3 @SergeyBiryukov
4 years ago

  • Component changed from Bootstrap/Load to Posts, Post Types
  • Milestone Awaiting Review deleted
  • Resolution set to duplicate
  • Status changed from new to closed

Hi @C3dRy2K, welcome to WordPress Trac!

Thanks for the report, we're already tracking this issue in #9864.

Related: #15459 #34982.

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?

That's the idea, yes.

Note: See TracTickets for help on using tickets.