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. The next_posts_link() works only with original $wp_query
  4. Adding additional data to WP_Post object
  5. Get current post id in functions.php
  6. Random sort within an already sorted query
  7. Get first post from wp_query
  8. WP_Query: Why is sticky post not first item in loop?
  9. WP_Query offset argument does not work
  10. Displaying the category name of a custom post type
  11. Query *only* sticky posts
  12. Search by Hyphen
  13. Skipping first 3 posts in wp query
  14. Exclude drafts in all() view of edit.php
  15. Exclude posts that only have the ‘Uncategorized’ category [duplicate]
  16. How do I reorder (pop and push) items from WP_Query?
  17. Accessing the post content with WP_Query
  18. Querying post from a multisite network
  19. How to exclude latest x posts from a paginated query?
  20. How to query serialized array by comparing greater than (>=)?
  21. How to know if get_posts() failed?
  22. Show related posts by category but ignore one category
  23. post__in for get_posts with a dynamic array
  24. Keep getting same permalink with WP_Query?
  25. Reverse chronology of post listing
  26. Query posts distinct authors
  27. WP_Query to work with custom view
  28. How to query posts with current or future date only
  29. How to get previous 10 days post from a specific date – WP Query
  30. WordPress Number of Posts Not Changing With posts_per_page
  31. Most viewed post for the last 2 days using WP_Query
  32. Adding Post Counts to Menu (Nav) Programmatically?
  33. Pagination not working on Custom Page Template
  34. This AJAX Code Doesn’t Work – Looking for elegant solution
  35. Create new WordPress post [wp_insert_post] based on results of a WP_Query
  36. Post content being duplicated by the_content();
  37. Get only modified posts
  38. How to add posts to wp_query result?
  39. Posts for next month
  40. Exclude posts with specific meta_value while sorting by a separate meta_value
  41. Specific loop in Shortcode
  42. Sort posts by activity date
  43. How to add padding between posts
  44. prevent showing posts of an specific category in admin posts section
  45. How to output comments number of a post per day?
  46. Working Bootstrap Carousel Conversion to WP – Technical Questions
  47. Search widget breaks when using multiple loops?
  48. WP_Query only ONE post, won’t work
  49. How to change bulk post status
  50. Add few specific post ids to wp_query
  51. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  52. Unable to modify(update) posts – Page not found
  53. Display the latest posts, published in the last hour, with WP_Query
  54. Replace Main Query With Custom Query
  55. Custom Order in WP Query
  56. Fetch posts from current week (Sunday to Saturday)
  57. If specific user role then sticky post
  58. Hide Post comments when displayed via WP_Query
  59. Search query – exact post title match
  60. Hiding posts in a list from specified categories
  61. Converting multiple loops into one single loop with pagination
  62. Display posts with comments closed, with pagination?
  63. Group posts by year in loop
  64. posts_per_page doesnt work
  65. WP_Query posts_per_page ignored
  66. wp query with dynamic taxonomies and terms?
  67. How would I get 1 latest post from a query for 5 posts?
  68. How to get posts by multiple post slugs? [duplicate]
  69. Blogroll – Different layout for first post
  70. How to get most recent commented post above new submitted post in WordPress?
  71. WP_Query do not load specifed number of post
  72. WP_Query: offset ignored when posts_per_page is -1?
  73. wp_query ‘s’ parameter does not work with custom post type
  74. How to start with post number x?
  75. WP Query related posts by current page Tag ID
  76. Exclude posts with empty post_content in wp_query
  77. Exclude posts from featuring
  78. I want to query posts in monthly basis
  79. Lazy Load using WP_Query pagination
  80. Only display a certain number of posts, dependent on how many posts there are available in a query
  81. How do I use `posts_distinct` correctly?
  82. AJAX filter posts by year
  83. How can I remove posts of a certain category from homepage after a specified time period?
  84. Automatic value for custom fields for posts
  85. How add class the_content();?
  86. How edit footer copyright info? [closed]
  87. Add custom PHP (no-SQL) filter to WP_query
  88. How do I get content of custom post type through post ID
  89. Filters do not work when there are multiple (one works)
  90. Get related posts matching most of the provided tags using WP_Query
  91. WP_Query post_tilte search in posts table
  92. date_query returning only the most recent post instead of the post published before today
  93. Image inside the content is replaced with featured image from my older post
  94. post loop with different design depending on post
  95. How to speed up WP_Posts_List_Table __construct() Query on a wordpress website with over 1 million posts?
  96. Implement AJAX ‘load more’ with offset posts
  97. Is it possible to use the_post 2 times in one loop
  98. Gutenberg block: add a multi-select for posts
  99. Order by Post Title in WP Query not working
  100. How to make WP_Query faster when getting a post from one year ago?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)