Update: OK now it's been mentioned between the time I started typing and the time I pressed submit. Damn you speedy fellow monks, damn you :-)

One approach I haven't seen mentioned, is that you could get 'smarter' about your dynamic-ness.

What I mean by that is design your system so that you can tell when a change has been made, so you always know when you need to regenerate your HTML.

So to translate this to your system, when a thread has an addition, generate the HTML code, store it, and mark the thread as clean.

Next time that thread is viewed, you only need to make a single database lookup to decide if you can re-use the HTML or not. If it's still clean, go for the cached version.

When additions are made to the thread, simply mark the thread as 'dirty', and the next time it's viewed, the HTML will be generated again.

Issues to think about here are concurrency, and also making sure everything that can affect the thread updates the dirty flag.

In reply to Re: Improving performance by generating a static html file? by Tardis
in thread Improving performance by generating a static html file? by BUU

Title:
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, details, 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, summary, 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.