Well, when I did something similar a very long time ago, I put a "next time to
fire" column in the table. Each time an event is fired, the application updates
that column.
Was a lot simpler than baroque searches for events that would need firing
between the last check and now. Was a lot cleaner
I'm not sure if this is the correct list for this, but I'm hoping to get
some help with a data model I'm struggling with. Let me know if this should
be elsewhere! :)
We have an event schedule system that basically tells an event handler when
an event should be fired, and keeps a history of fired
