chuckd:

Just as a counterpoint to BrowserUK's comments--I use DBD::ODBC nearly exclusively.

My workload is basically: use the bulk loader to get the data into the database, and use vanilla SQL to operate on the data. For this usage, ODBC has been just fine for me. One thing I commonly hear is that "ODBC is slow". It might be, but I haven't seen any speed difficulties. Of course, I don't execute a bazillion tiny queries--I tend to tell the database to do large operations so that the communications overhead is pretty darned small. So I think I'd advise: "If you're already using ODBC for other databases, go ahead and use ODBC. If you find a speed or feature deficiency, you can always go to DBD::Oracle." In fact, that's what I decided long ago. I've just never been pushed onwards.

Having said that, you'll still need the oracle client software on your machine to use the ODBC interface, so installing DBD::ODBC probably won't save you any time or effort on the installation phase. So if you don't have DBD::ODBC on your machine, and you don't anticipate doing so, you might just try DBD::Oracle first.

...roboticus

In reply to Re: DBD::ODBC vs. DBD::Oracle by roboticus
in thread DBD::ODBC vs. DBD::Oracle by chuckd

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.