Ticket #6561 (closed defect: fixed)

Opened 8 months ago

Last modified 4 months ago

handle thousands of pages

Reported by: hailin Assigned to: hailin
Priority: normal Milestone: 2.6
Component: General Version:
Severity: normal Keywords:
Cc:

Description

#

This isn't one issue, it's several, but they're related.

TRAC Ticket #5303 fixes hundreds of pages issue; when there are thousands of pages, it is still very slow. It might be -better-, but the scaling issues are present even in 2.5, and they're severe enough that it's grinding my WP install to a halt as I continue to import pages.

Now, to be clear, I have a -lot- of pages. My current test environment has just under 4000, so it takes quite some time to render all those out on one page.

It seems to me that the simplest solution is to rewrite edit-pages so that it paginates, the same way edit-posts does. Is there a reason that this hasn't been done already?

Similarly, if you edit any page (with thousands of pages in the DB), it will take a few minutes minute to render the page-editing screen. The bottleneck is the parent_dropdown function. As a hack, I've removed the box entirely from my page-editing screen (and in the meantime i can use the pageMash plugin if/when I want to change page parent/ordering), but this isn't a long-term solution. Obviously, the "page parent" interface box wasn't designed with this many pages in mind, and I'm going to think about a new design which scales well that I can write as a plugin (or a patch). Any thoughts you have are appreciated Posted: 2008-04-02 18:15:51 # #

josephscott Member

Having edit-pages support pagination has been brought up, but hasn't been tackled yet. I suspect the parent-child relationships for pages makes this harder to do that edit-posts.

I'll ramp up a test blog with many pages and see what options we have on making it better.

Just so I'm clear, the two places that this has been the biggest problem is "Manage -> Pages" and "Write -> Page" (page parent box), correct? Are there any other places where you've seen major problems? Posted: 2008-04-02 21:32:31 #

Attachments

edit-pages-paged.patch (4.4 kB) - added by ramenboy on 06/06/08 16:34:42.
Add paging to manage pages on WordPress 2.5

Change History

04/03/08 02:47:35 changed by hailin

  • owner changed from anonymous to hailin.
  • status changed from new to assigned.

I will take a look.

04/03/08 17:32:18 changed by lloydbudd

Relates to #2004

04/04/08 15:19:58 changed by randyhoyt

I think the "Parent Page" option could handled in a dialog box, in much the same way the upload feature was moved off the page itself. The parent page isn't something that will change often, probably just the first time you create a page.

04/04/08 15:22:16 changed by randyhoyt

I imagine the "Manage Pages" page isn't paginated because of their hierarchical nature; what if you got to the end of a page (say 20 records), but record #21 was a child of record #20? I don't think this is an impossible issue to overcome, but it will need to be considered.

06/06/08 16:34:42 changed by ramenboy

  • attachment edit-pages-paged.patch added.

Add paging to manage pages on WordPress 2.5

06/06/08 16:42:57 changed by ramenboy

I have submitted a patch that adds paging support the "Manage Pages" page on WordPress 2.5. It queries only the fields necessary for display, rather than loading every page into memory like the current version does. If the first item on a page is not a root, its parents are prepended with "(continued)" in the title so that you don't lose your place in the hierarchy. "Manage Pages" loads in about 1-2 seconds now, where it used to take 10-20. We have about 500 pages.

06/15/08 00:45:02 changed by ryan

(In [8089]) Add paging to Manage->Pages. see #6561

07/12/08 14:23:20 changed by hailin

  • status changed from assigned to closed.
  • resolution set to worksforme.

07/30/08 00:51:44 changed by thee17

  • milestone deleted.

07/30/08 01:10:22 changed by jacobsantos

This should be marked as fixed and not as worksforme.

07/30/08 01:12:19 changed by ryan

  • status changed from closed to reopened.
  • resolution deleted.

07/30/08 01:12:23 changed by ryan

  • status changed from reopened to closed.
  • resolution set to fixed.

07/30/08 01:12:45 changed by ryan

  • milestone set to 2.6.