Hmm, I've never heard this before. Perhaps that is because I am about as anti-php as anyone can be.

So, you get a huge performance boost because of connection caching? Is it caching, or multiplexing?

The one problem I've run into before with connection caching is that it tends to keep the connections open. Why is this bad, you ask? Well, every open connection to the database requires resources (mainly memory space). So if your website gets a hard hit, the first few accesses are going to be fast, but you will reach your performance ceiling very quickly.

Also, why would you want to use a programming language that requires a different api for different databases? With perl, it doesn't matter what back end you use, you always get all of DBI's functionality and utility methods.

I would tend to think that php tends to dictate the database backend you use. Just imagine: "We wanted to use <your database software here>, but the interface in php sucks compared to mysql, so we have to use less robust backend software."

In reply to Re: Perl vs. PHP: databases by DrZaius
in thread Perl vs. PHP: databases by elusion

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.