I do not think that there is any sane way to sort this issue with the amount of posts you have except than setting hierarchical to false. Setting hierarchical to true has huge impact on performance and aren’t really meant for use in custom post types.
If you do not need a parent/child relationship between posts like the build-in post type page have, then you should really set hierarchical to `false. If you really need that relationship, then you are pretty much stuffed unfortunately. With the amount of posts you have I cannot see any viable solution to sort your issue
Just a tip, remember to flush your permalinks after setting hierarchical to false
Related Posts:
- Backend search; include CPT meta?
- How to programatically set the post title of a CPT on wp-admin
- Display custom fields from custom posts in RSS feed
- Tracking changes in admin-page so user gets warning when leaving the page
- It’s possible to hide body copy box for a custom post type?
- Custom Field values not Showing in Edit Page of Custom Post Type
- Change Post Meta via AJAX from the posts list table
- WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
- Sort custom post column by generated value?
- Simple Data picker meta box
- Query Distinct Taxonomies of Custom Post Type
- Custom post type won’t take my custom fields
- Show a custom field instead of username in the backend author area
- Add meta value to custom post type on publish
- convert custom query to wp_query
- Wrong request query on cpt and tax
- How can I dynamically add a post to a custom post type which uses a custom field?
- Admin Pointers on a custom post type
- Filtering custom post type on a combination of custom taxonomies and custom fields?
- Custom Posts Types as Custom Fields
- Get image post ID in media upload
- using $wpdb to get custom post type with term
- Why is my select meta data not saving?
- dynamically add a custom field or metabox to custom post type [duplicate]
- Give a permalink to Custom Post Types without title
- Add a button or image button that calls wp functions in the wp-admin
- Role scoping for contributors down to the field level
- How to implement a Google map store locator
- Creating a Custom Post as a repository for theme constants
- Converting the_content string to an array?
- search also in taxonomy, tags and custom fields
- Random image from tag/custom type on sidebar
- How to stick custom post at the top in search results
- Selecting a post in Dashboard
- Custom Post List View: Page or something else?
- How do I create custom fields for multiple post types?
- Custom admin post.php page
- Add field to all custom post types
- Query & Order posts by custom fields
- Custom Taxonomy back-end customizations
- Filter custom posts using auto populated dropdown selectors
- How do I display content to users who are not logged in instead of 404 on Private custom posts?
- How do I associate a custom post type with another through a taxonomy or storing an ID in a custom field?
- How to add a custom-post-type post within another custom-post-type post edit screen using AJAX?
- Custom post type content using custom fields without template
- Cannot add custom field to “orderby” parameter in Rest API
- What is the recommended / best way to do this: Event calendar post/type in a block-based theme?
- retrieve Meta field value from CPT and set those values as Image Meta Field “Title”
- Having unique constraints for custom fields in a custom post type
- Help with Elementor Pagination CPT archive 404 problem
- Querying Two Custom Post Types with OR Not Working
- How can I get the number of custom post type posts that have a specific attachment image set?
- Trash / Draft a WordPress custom post after custom date field expires
- Set a maxlength for the title input in a custom post type
- Posting to a Custom Post Type from front end – user generated content
- Bulk Update Custom Fields for Custom Post Types
- How can I use get_post_meta with add_rewrite_rule to build custom permalinks?
- Visual editor issue by having multiple tiny mce editors in a CPT
- WordPress Custom Fields Won’t Save
- Update Post Meta for a logged in user
- Problem querying Custom post type by custom fields
- Found 2 elements with non-unique id (#_ajax_nonce) and (#_wpnonce)
- Add custom field to Posts and sort by it
- Orderby CPT custom fields not working
- WP_Query order by custom field, then randomly order some of results
- A better way to add a meta box to custom post types
- Rows with custom columns not well formatted after Quick Edit save
- Trouble with CPT Child 404
- Plugin – Combine Meta Box Input Fields into single saveble record
- Two Custom Post Types Many to Many Relationship
- Filter term taxonomy metabox in custom post type
- Show custom post type relationships by taxonomy
- get_post_meta not working on publishing
- Query custom post type with ACF Date
- Custom setting to show or hide field
- Custom Meta Field – Remove comma from string with str_replace
- CPT post count is 0 for the authors in the User list
- Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
- Using custom field content as expression in IF statement [closed]
- Meta Query Not Returning Output Despite Having Matching Values
- Using taxonomy term in CPT permalink – Pages 404’s
- Addition of custom option panel crashes Media Library & Admin Area
- How to create a custom post type with additional fields?
- Callback to custom field is not working in WordPress REST API
- Meta Query Filtering not working on Custom Meta Box using Radio Buttons
- Including metaboxes from custom post types in global search — continued
- ACF From & To Date Validations
- How do I set all of a particular post meta to a value within the custom post type I’m in?
- Query Multiple Custom Posts by Custom Fields
- Show image gallery from a custom field
- Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
- Custom post URL 404 error
- Dynamic dropdown select values depending on other custom field value
- How to render a custom post type template with custom fields using shortcode
- Disable saving posts as draft (make all posts mandatory regardless of the post status)
- Grouping metadatas into one
- filter custom post in rest api with custom function
- Get Posts by multiple custom fields is not working
- Single post with a Custom Post Type returns 404, when archives of the CPT work correctly
- Possibilities for the edit.php admin panel? [closed]