You've probably received more comments than you want or need.  However, I will call your attention to a recent article in e-week (part of Ziff-Davis and connected to PC Magazine) comparing the top database programs:  Oracle, MS SQL, mySQL, and a few others.  Oracle and mySQL seemed to do the best when compared on performance, and when you consider the basically free price of mySQL, it did the best.  However, there were some differences that are worth knowing that don't necessarily make any one database the absolute best, as many Perl Monks have indicated above.

This e-week article was based on the results of an extensive comparison that they did amongst these databases.  They pushed the databases to extreme levels: for instance, they tested them for four weeks, retrieving something like up to 600 pages of data per minute for eight continuous hours per test to see if each database could hold up and to see how many pages of data they could retrieve per minute.

It's not a long article, but the process they went through and the results of their intensive testing is quite amazing.  It's a good background article for anyone who works with databases to read.

That's Spenser, with an "s" like the detective.

In reply to Re: Perl and Databases by Spenser
in thread Perl and Databases by NAstyed

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.