If I may offer some comments...

At a previous job I implemented a message board type system using DB_File (although the rest of the site used Sybase). This was for a large site (several million users), but the number of messages per forum was expected to be small (i.e. several million forums, but each one quite small).

This worked really well, until the system was bought out by another company that wanted to migrate their message boards to our code base. They had 40000 boards, some of which had several thousand messages, and requirements that differed enough from the original code to cause some serious performance problems due to the need to look through the entire DB file to get the information that was needed.

Ouch.

So I ended up re-implementing this code to use a relational database back-end (which was actually quite easy for this particular task).

So - what I mean to say is that using a database engine is a good idea - it makes things easier to extend, and it allows you to make performance decisions at the database level.

I'd also like to add that you can get Sybase 11.0.3.3 completely free for linux. It's not the latest version of Sybase, but it is stable, and offers stored procs, etc.

Just my opinion, of course :-)

Michael

In reply to Re: exploring XP DBI DBD DBM SQL RDMS MySQL Postgres by mpeppler
in thread exploring XP DBI DBD DBM SQL RDMS MySQL Postgres by mandog

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.