Automatic post deletion

You can improve by storing the “expiry” time of post as a meta instead of the publish time. This way you can query for posts with meta which is smaller then the current time and draft them, no need to loop over all posts.

Drawback is that you will have to decide how to handle changes to lifespawn time, just ignore this edge case or adjust all posts.

Related Posts:

  1. How to limit the number of posts that WP_Query gets?
  2. Should we trust the post globals?
  3. Get current post id in functions.php
  4. Get first post from wp_query
  5. WP_Query offset argument does not work
  6. Querying post from a multisite network
  7. How to know if get_posts() failed?
  8. Show related posts by category but ignore one category
  9. post__in for get_posts with a dynamic array
  10. Keep getting same permalink with WP_Query?
  11. Query posts distinct authors
  12. How to query posts with current or future date only
  13. Pagination not working on Custom Page Template
  14. Create new WordPress post [wp_insert_post] based on results of a WP_Query
  15. Post content being duplicated by the_content();
  16. How to add padding between posts
  17. prevent showing posts of an specific category in admin posts section
  18. Working Bootstrap Carousel Conversion to WP – Technical Questions
  19. How to change bulk post status
  20. Add few specific post ids to wp_query
  21. Custom Order in WP Query
  22. Search query – exact post title match
  23. WP_Query posts_per_page ignored
  24. How to get most recent commented post above new submitted post in WordPress?
  25. wp_query ‘s’ parameter does not work with custom post type
  26. How to start with post number x?
  27. WP_Query get posts from custom posts by category
  28. Accessing post->ID outside of the loop for listing child pages
  29. WP Query – duplicated posts once including tags in search results
  30. List posts in a given category
  31. Reset Popular post query?
  32. Query Posts multiple conditions
  33. how to get posts ids inside pre_get_posts filter?
  34. Future post ID not showing
  35. How do I use WP_Query to get a range of posts with custom fields that have numbers with letters in them?
  36. recent posts for different categories
  37. Search by post title and content in wp_query without order
  38. Change post order random through out the entire WordPress
  39. Setup a custom dynamic post
  40. Anyway to grab author name and featured image in an embeded in inital array of posts outside of loop?
  41. Removing noindex posts from wp_query
  42. How safe is renovating $wp_query when doing WP_Query pagination in Page Template
  43. Exclude the first ‘n’ number of posts of a tag from home page?
  44. how to change the number of posts returned in a specific loop without making it global?
  45. posts_per_page option limits the number of Gallery items
  46. Nested WP_Query breaking loop
  47. Why Query is returning empty array?
  48. meta_value timestamp older than now
  49. Get posts with multiple categories
  50. Do not show children of a category
  51. Query for first 3 posts to change the look and feel
  52. Getting blog pagination to work on page set as front page
  53. search blog posts by author first name and or last name
  54. unique post in “$args” of wp_query display more than one post
  55. Display current post position in Elementor Posts widget
  56. How to give classname to post if post has no content?
  57. Custom wp-query in wordpress rest api
  58. posts_per_page returning only one post
  59. Need to know custom code to display random and most viewed posts in wordpress posts and pages
  60. How to retrieve certain number of images from a wordpress post?
  61. WordPress post filter menu
  62. How to display post list in a table layout (multiple queries in single loop)
  63. Not all posts showing in query
  64. WP_Query custom field pass the post id
  65. WordPress query portfolio posts
  66. Current and next month posts
  67. Get latest author posts inside the loop
  68. Same post appears in related Posts?
  69. Display 3 posts with different HTML markup using a loop
  70. How to show multiple posts thumbnail, title and date in widget
  71. WP_Query outputs wrong post in custom post type
  72. how to show comments only author which send own posts in wordpress
  73. Group first, 2nd, 3rd, etc posts by category terms
  74. Manipulated offset and pagination, can’t display last post anymore
  75. How to sort WP_Post Object array by object field in php?
  76. Order by meta_key field in WordPress not meta_value field value
  77. How to display particular set of wordpress post on a webpage?
  78. How to create page with post content in it?
  79. How to remove a post from results by ID after query?
  80. Show 5 posts and than 3 posts offset with pagination
  81. Override wp_link_pages pagebreak with filter
  82. WP_Query extended with AJAX
  83. Is it possible to query a category with specified posts?
  84. Blog only showing one post even though more published
  85. WordPress loop uses unmodified posts array, why?
  86. Sort / Filter Queries
  87. Show posts between two Custom Fields date
  88. Query to get data of a post, if in category?
  89. Order posts by custom field
  90. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  91. How do I control the fallback query after the original query returned cero posts?
  92. Remove duplicated posts in the loop if post has more than one category
  93. Order posts by separate menu order for different sub-categories
  94. Adding a category at even positions on main loop with modified pagination
  95. Why I getting only 1 post?
  96. What is wrong with this wp_query?
  97. Exclude sub sub categories from displaying in the archive page
  98. First post in loop displays twice
  99. date_query returning only the most recent post instead of the post published before today
  100. Is it possible to use the_post 2 times in one loop