Using DBI you have access to full SQL dialect of your database engine, and flexibility of perl. Don't do object if they will slow processing down, you do not have to. I suggest then to take plain old shared libraries to access database.
Try solve 80% cases of data access in your shared code, and for 20% high performance use custom SQL. I guess Knuth said that root of all software evil is optimalization too soon -- so don't do that if you are strong enough to resist...
I know it's hard not to optimize - because it is more fun, I am struggling with it too... ;)
About MySQL: there are many threads all over Net that MySQL can be faster because does not have support for transaction. From your description I am guessing you need trasaction? For this many rows, ORACLE will be safer bet, IMHO.
I am working on such an API right now, but sorry it is not ready yet...:(

pmas
To make errors is human. But to make million errors per second, you need a computer.

In reply to (pmas) Re: plsql vs. perl vs. neither and API's (code) by pmas
in thread plsql vs. perl vs. neither and API's (code) by deprecated

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.