Hi everyone! Ok, here is the problem:
@ work we have some system (kinda portal with user's discussions) which runs under mod_perl and MySQL.
But, we have some major problems with preformance - it takes about 10 seconds to get the result while browsing the structure - because of all the SELECTS that have to be done (it takes about 8 seconds for MySQL to process these SELECTS).
So, while moving to mod_perl is not an answer (we are already here) and changing the structure itself not an aswer too we came to idea of moving the "structure browsing" to static files.
The site suffers a peak load of about 100 sessions per webserver (there are 4 of them, sharing one www diskspace via NFS).
In the peak time some part (at most 1%) of the structure may be rebuild about 1 time for minute.

Now the question(s): does migrating to static files is resonable in our case?
If no - than any ideas to improve the preformance (except buying more hardware :-)
If yes - where we can shot ourselfs in foot? (ok, file-locking while modyfing static files is obvious)

Thanks in advance

Peter

In reply to Migrating to static structure? by pit

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.