in reply to
Re^3: storing and 'understanding' complex calendar events (including recurring events)
in thread storing and 'understanding' complex calendar events (including recurring events)
Well, you either need to store the definition for the event or the complete list of events. Storing the definition and expanding it to the full list when needed keeps the database of events simple and easy to work on. On the other hand, it's probably going to be pretty slow when you need to go through the list and calculate if each event matches a given day. The opposite is true of storing an expanded list of dates for each event. It's a trade like everything else.