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. The next_posts_link() works only with original $wp_query
  2. WP_Query: Why is sticky post not first item in loop?
  3. Query *only* sticky posts
  4. Skipping first 3 posts in wp query
  5. Accessing the post content with WP_Query
  6. Get only modified posts
  7. How to output comments number of a post per day?
  8. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  9. If specific user role then sticky post
  10. Hide Post comments when displayed via WP_Query
  11. Display posts with comments closed, with pagination?
  12. posts_per_page doesnt work
  13. I want to query posts in monthly basis
  14. Custom WP_QUERY $args
  15. Improving WP_Query for performance when random posts are ordered
  16. Why won’t my taxonomy query show up?
  17. How to find what index page a post is on?
  18. Display post from current category and same tag?
  19. Get Posts that are in the current month or later
  20. WP Query to Get Array of Slugs
  21. WP_Query with ajax handler returns the same posts
  22. Why WP_Query(‘showposts=5’) shows only 1 post?
  23. How can I sort posts by the date and a custom meta field?
  24. Hiding Draft Post In Admin
  25. How to insert 2 args into 1 Wp_Query for a slideshow
  26. How to verify wp user password by sql query in wp? [closed]
  27. WP Query – Posts Per Page not working in combination with category__in
  28. How to filter my search in post if contains a word in title, content or excerpt?
  29. Lost draft under all posts and drafts
  30. Get user categories with most posts in it
  31. Query posts and return XML
  32. how to change the number of posts returned in a specific loop without making it global?
  33. List authors with the last post title and order by last post date
  34. How to order posts by meta_value and title
  35. Adding a blog archive with pagination using WP_Query
  36. Nested WP_Query breaking loop
  37. WordPress query_posts by tag doesn’t work anymore(?)
  38. Why Query is returning empty array?
  39. Ignore latest two posts
  40. Show posts by author of membership level (Paid Membership Pro)
  41. meta_value timestamp older than now
  42. Print out last 3 blogposts
  43. Query for first 3 posts to change the look and feel
  44. Why posts array is empty?
  45. Getting blog pagination to work on page set as front page
  46. How to group only VISIBLE posts? [closed]
  47. How to check in functions.php if there is data in a WP_Query?
  48. Shortcode with ‘year’ parameter
  49. search blog posts by author first name and or last name
  50. On what hook can I get the queried object’s final state?
  51. unique post in “$args” of wp_query display more than one post
  52. If no posts exist for current day and month, show the next available day of posts
  53. How to display post list in a table layout (multiple queries in single loop)
  54. Not all posts showing in query
  55. Get all custom posts with a certain taxonomy
  56. Link to date_query results in WordPress
  57. Query function not executed between element [closed]
  58. When WP_Query only returns 1 post, how do I automatically redirect to that post?
  59. WordPress query portfolio posts
  60. Get latest author posts inside the loop
  61. Limiting post list by taxonomy
  62. Display 3 posts with different HTML markup using a loop
  63. Is there a function to get post info for any publish_status by post ID?
  64. How Can I Always Display A Particular Post First Using WP_Query?
  65. How to show multiple posts thumbnail, title and date in widget
  66. Group first, 2nd, 3rd, etc posts by category terms
  67. Manipulated offset and pagination, can’t display last post anymore
  68. Function is printing twice – any suggestions?
  69. How to display particular set of wordpress post on a webpage?
  70. Order posts inside bootstrap card columns
  71. How to use two query result together in one loop
  72. show loop id post , only first id can read
  73. Page with Category Returning 1
  74. filter posts based on menu_order
  75. Show 5 posts and than 3 posts offset with pagination
  76. Change archive results based on GET request
  77. Get 5 most recent categories
  78. Wp_query loop is not working as it should
  79. Show all posts from the tags without having to set all of them
  80. Is it possible to query a category with specified posts?
  81. Is there a global page/post/product/anything ID?
  82. WordPress loop uses unmodified posts array, why?
  83. wp query custom orderby not custom field
  84. Show posts between two Custom Fields date
  85. Query to get data of a post, if in category?
  86. Order posts by custom field
  87. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  88. Remove duplicated posts in the loop if post has more than one category
  89. Retrieve latest post by multiple categories with ID
  90. How to Include a common category in a custom Category Search
  91. Why I getting only 1 post?
  92. The next_posts_link() works only with original $wp_query
  93. Limit amount of pages shown in pagination within wp_query
  94. custom sort posts in archive/taxanomy page
  95. First post in loop displays twice
  96. Trying to create shortcode listing custom posts, but formating not being included
  97. Show Title/Date/Excerpt of first post & only Title for rest in Query [duplicate]
  98. Get posts after calculating meta key
  99. Get related posts matching most of the provided tags using WP_Query
  100. WP_Query post_tilte search in posts table
tech