Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

comment on

( #3333=superdoc: print w/replies, xml ) Need Help??
Hi there, long time, no ask!

I've been tasked with the implementation of a event-based website, a bit like, only that we have to support recurring events, which, as many might know, are a royal PITA to handle.
My plan was to precalculate events, and insert one entry into the DB for each ocurrence of the event, in order to make the retrieval of the data (which will hopefully be very frequent) quick and simple. My partners insist that this is not elegant, and that events should be stored as they were created with the recurrence-information stored a la iCalendar, and that each time we show a calendar or a list of events, we re-calculate whether a given event applies to the current time-span or not. This seems to be the approach that most webcalender-software solutions take, but this seems like a daunting waste of computational resources to me.
We cant be the first ones to ponder this problem, so does anyone have any hints or caveats of either approach (precalculating recurring events vs. storing only the recurrence-information) on hand?


P.S.: does anyone klnow of any accepted feed-format for event-information? I could only find iCalendar, and maybe RSS-with-embedded-xCal information, which sturck me as odd.

In reply to precalculating event dates vs.recalculating them. by schweini

Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others chanting in the Monastery: (5)
    As of 2020-06-03 07:56 GMT
    Find Nodes?
      Voting Booth?
      Do you really want to know if there is extraterrestrial life?

      Results (21 votes). Check out past polls.