Admin slow on Postlist (over 30k Posts in Database)

Perhaps this filter can help you to modify the query for the specific post type and inside wp-admin

as per the documentation, this filter is called before the query is executed so you can modify/optimize the query with the help of this filter.

do_action_ref_array( 'pre_get_posts', WP_Query $query )

further reference: https://developer.wordpress.org/reference/hooks/pre_get_posts/

Related Posts:

  1. How to make post sticky in the admin page?
  2. Remove rows in the manage post/page view
  3. How to add a custom-post-type post within another custom-post-type post edit screen using AJAX?
  4. How do I edit the WordPress post.php file?
  5. list articles in admin showing nested categories or slugs?
  6. How we can create menu from Appearance > Menu and use as a add-submenu-page for admin menu?
  7. Publishing failed. The response is not a valid JSON response
  8. Limiting the Number of User Posts to Their Own Posts
  9. Display posts of only a certain category in WP Admin section?
  10. Storing posts from query and accessing later via AJAX call
  11. If post has custom field then display css-class
  12. Display only one post each WEEK
  13. List children on child post
  14. Restrict custom post type from appearing with ?post_types=
  15. Admin Pointers on a custom post type
  16. Show custom post type filtered by category
  17. create parent post using wp_insert_post
  18. Turn on and off custom post type from admin?
  19. Missing Posts in Custom Taxonomy List
  20. Display random posts, but omit the post it is on?
  21. How do I do this with WordPress? Taxonomies?
  22. Add a button or image button that calls wp functions in the wp-admin
  23. Disable block with taxonomies at post page
  24. I would like to have different styles for my posts based on the content of each post
  25. How can i add thumbnails images to particular post (using code not admin pannel) in wordpress
  26. Showing posts from different categories and from custom post type
  27. Get latest 3 posts from multiple CPT in one query
  28. Selecting a post in Dashboard
  29. Custom Post List View: Page or something else?
  30. Allow non-logged in users to see a future post after clicking on a list of future posts
  31. Which post does a taxonomy term belongs to?
  32. Custom admin post.php page
  33. List custom taxonomy specific to one custom post type
  34. Custom Taxonomy back-end customizations
  35. Post image in WordPress not appearing on home page
  36. Meta query for custom post type ignored in main query
  37. Changing custom type name hides the posts
  38. Display Ad on Specific Categories
  39. Hiding posts by other users and non-logged in
  40. Update Post Meta for a logged in user
  41. Add custom field to Posts and sort by it
  42. Add custom post type settings to wordress default posts
  43. Get related posts of child term of custom post type
  44. Two Custom Post Types Many to Many Relationship
  45. Problem with displaying posts in the CPT category
  46. Filter term taxonomy metabox in custom post type
  47. JS innerhtml changing style when using AJAX
  48. Show titles, date of all posts on single category page
  49. CPT post count is 0 for the authors in the User list
  50. Addition of custom option panel crashes Media Library & Admin Area
  51. Side effects of Script and Iframe in post
  52. How to change the post type a theme shows by default?
  53. Tracking changes in admin-page so user gets warning when leaving the page
  54. Set a checkmark in a category based on a URL-parameter
  55. Several post types on WP Query by tag and taxonomy
  56. Possibilities for the edit.php admin panel? [closed]
  57. No Permission to add new Page, Post or CPT with Admin role
  58. Update postmeta Parent when post_status child change
  59. custom post type category count shortcode
  60. Portfolio Page for Classic Posts
  61. Filter hierarchical custom post type admin page by parent, and include children & grandchildren
  62. Admin Filter – Add Post Type Description on Post Type Page
  63. Add post location with mile radius allowing search
  64. Custom post type editor with dynamic selects, one drop down populating a second second drop down not working
  65. Get the category from custom post type
  66. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  67. Set up post page like JAMA articles
  68. Custom Post Slug same as Parents Category Slug
  69. Shortcode not working with post counter
  70. WP-ADMIN – Listing all CPT in “posts” listing
  71. Changing default ‘posts’ parameters with register_post_type_args
  72. Admin Column does not populate with data
  73. manage_edit-{post_type}_sortable_columns sorts, but wrong!
  74. How to integrate a form (Ninja Form or Contact Form 7) with Custom Post Types?
  75. Prioritize posts in query by meta keys?
  76. Homepage’s content is dependent on the custom field values (set automatically), how do I get homepage to update without manually updating page?
  77. Allow users to create posts without logging in?
  78. How to get all tags of a custom post type by id
  79. How to define which register_post_status goes to which register_post_type?
  80. Load Next Posts With AJAX not working with custom post type
  81. Limit the post for differents custom post type in the same wp_query
  82. Custom Postype specific changes in admin panel
  83. Grouping of CPTs and taxonomies into menu groups in admin
  84. 2 Different Custom Post Types in Submenu
  85. How to assign classes to all elements?
  86. How can I show 1 featured post in a styled element, and the next few below differently styled
  87. Some posts from custom post type to subdomains
  88. How can i create an custom post template for an specific post category? [closed]
  89. How to sort posts in a custom post type by title in ascending order by default?
  90. It’s possible to hide body copy box for a custom post type?
  91. WP the_posts() on single-cars.php get category link
  92. Conditional for a Single Post That Belongs to a Category?
  93. $post not working working in AJAX plugin with custom post type
  94. Permalink misbehaving in Custom Post Types
  95. Show data from one Custom Post Type in another Custom Post Type
  96. Check post on publish for blank title
  97. how to check if custom post title exists or not?
  98. Different Limit number of post on different archive page
  99. How to change “post_class()” for a custom post type?
  100. Modify previous and next post links to current Authors Other posts
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)