When inserting to a DB, the very most important thing is the number of transactions per second. If you try to run a transaction per insert, this will just "auger into the ground" performance wise. The DB will be limited by transactions per second. You can easily insert one million rows in a single transaction.

I have no experience with Oracle, but the basic principle I mentioned above is true for all SQL DB's.

Update: A DB transaction leaves the HD in a known state - no matter what happens during the transaction. This requires multiple writes and reads with associated rotational hard disk delays. A million row insert may not take much longer than a single row insert. That is because of all of this "book keeping" is related to number of transactions, not the amount of data or the number of rows.

In reply to Re: DBD::Oracle insert row performance by Marshall
in thread DBD::Oracle insert row performance by pme

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.