haveboardI 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?
