Support » Fixing WordPress » hierarchical post type w/ heavy data set fails (lots of custom fields)

  • I am a developer building a custom system for a client and think I discovered a bug in the way hierarchical post types are handled when they contain a lot of custom fields.

    /wp-admin/edit.php?post_type=test fails when hierarchal is set to true and there are a lot of posts with a lot of custom fields.

    Having 100+ custom fields is a lot but why can I not view the list in the back end with hierarchal true with such a heavy data set .yet it works just fine when set to false

    I had ~3000 entries in a custom post type ‘test’ which each had about ~100 custom field values.

    I decided to set up a test with a clean install of WordPress using twenty eleven as theme.

    I created a custom post type of ‘test’ and imported test data of ~30000 entries with no custom fields

    I then began importing data with ~100+ custom fields with data.

    Once I got to about 700 entries each with ~100+ custom fields, the server stopped handling requests to /wp-admin/edit.php?post_type=test

    hierarchical true (30,699 entries)
    Total 16 queries, time taken: 3.4486s

    hierarchical false (30,699 entries)
    Total 17 queries, time taken: 0.44286s

    hierarchical true (30,700 entries)
    Fails – server error

    hierarchical false (30,700 entries)
    Total 17 queries, time taken: 0.04813

    There are no error logs being generated on the server and for reasons I cannot disclose, I don’t have much flexibility or support from the webhost.

    Does anyone have any idea why there is such a major difference with hierarchical set to false?

  • The topic ‘hierarchical post type w/ heavy data set fails (lots of custom fields)’ is closed to new replies.