I wanted to turn to you all to get some advise before I embark on my first WP Scheduled event solution. I am looking to employ a cron job to remove expired events. This is not a robust solution for a complex event scheduler it's a simple date (maybe time) based event.
I use formidable pro to create the events and render views of all the events. When a user creates an event I have formidable also generate a post with the event information as well as a tag for the google map plugin. The purpose of the event expiration is to remove the post, so that the event will no longer appear on the map.
The best practice advice I am seeking is to chose between two approaches to the solution.
I can create a recurring event that on some interval (day or hour) looks at all the event posts and determines if the event has expired and then deletes the post.
I can create a one time event for each post upon creation that sets an expiration time based on the post custom fields date (and time, hopefully, for better acccuracy)
My concern is that creating events for eah post might be A LOT of events, and I do not know if that poses a problem for WP. I am assuming that a recurring "sweep" of all posts is a less resource intensive process. I do now know for certain, though, since a sweep across all posts each time someone visits site on an hourly basis may be more consuming than single events deleting each post on it's own.
I appreciate your feedback on this. Once I get some direction, perhaps I can present some code for your consideration.