A quick note:

This applies for sure to MySql, but I'm pretty sure that it's an across the board thing as well. When a database is on the same machine as the process querying it, it uses ultra fast Unix domain sockets to return data. If you put it on another machine then you are reduced to using the slower TCP sockets. If you are using CGI, and not mod_perl, then I'd advise putting the database on the same box as the script, and then using "localhost" to call the database. If you have the DB on a separate box, then you'll have to allow the DB to recieve queries from the machine that you are on, and you'll have to specify the hostname somehow... and that will be slower.
_______________________________________________
"Intelligence is a tool used achieve goals, however goals are not always chosen wisely..."

In reply to Re: Ha! Another database question! by chorg
in thread Ha! Another database question! by r.joseph

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.