And as for optimizing my mysql queries, can you point me to a good reference or give me some tips?

First, joealba had mentioned to make sure that your database tables have good indexes and keys - and he is right.

From experience (of not doing this the first time around) I would add to make certain that your database is properly normalized BEFORE it gets large and painfully slow to query.

There are plenty of good places to look for info on this. Go to Google and search for 'MySQL database normalization' -- for that matter, look at mysql.org for hints.

You know that you are in good shape if you can get whatever you are looking for with an absolute minimum number of query statements using table joins. One query is obviously ideal. If the query is slow, you may want to rethink your keys/indexes.

The performance benefits of a persistent database connection has already been addressed. If you can, I would suggest using it.

my $.02

In reply to Re: Re: Improving performance by generating a static html file? by shambright
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.