RE: Faster Inserting Code

From: Jared Still (jkstill_at_cybcon.com)
Date: 09/25/04

  • Next message: Jared Still: "RE: Faster Inserting Code" 
    To: "Reidy, Ron" <Ron.Reidy@arraybiopharma.com>
Date: Fri, 24 Sep 2004 19:09:50 -0700

    On Wed, 2004-09-22 at 15:35, Reidy, Ron wrote:
    > Well, since you're using Oracle, modify your do() and prepare() statements as follows:
    >
    > $dbh->do("sql statement", {ora_check_sql => 0}) ...
    >
    > $dbh->prepare("sql statement", {ora_check_sql => 0}) ...
    >
    > And you will make your DBA happy.
    >

    Unless I'm misreading the docs on this, I don't see where it
    will make any difference in the script in question.

    Care to enlighten me?

    Jared

  • Next message: Jared Still: "RE: Faster Inserting Code"

    Relevant Pages

    • RE: Introduction
      ... On Thu, 10 Nov 2005, Reidy, Ron wrote: ... installation of Oracle is different enough to stump Makefile.PL - so my ...
      (perl.dbi.users)
    • RE: Oracle cursor help
      ... Lead DBA ... To: Reidy, Ron ... part that surprised me was the truncate. ...
      (perl.dbi.users)
    • Re: Rounding numbers up or down
      ... Ron, they are formulas for the most part - I'd like to automate the whole ... I'll try to modify the formula to see if it works. ... > Dim AOI As Range ... AOI) Is Nothing Then GoTo DONE ...
      (microsoft.public.excel.misc)
    • RE: DBD-Oracle error when inserting a date
      ... To: Reidy, Ron ... I'm binding in the execute statement. ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • RE: performance problem with dbd oracle
      ... On Fri, 2004-04-16 at 09:24, Reidy, Ron wrote: ... Nothing you ever write in Perl will give you the insert speed you will get with this utility. ... > How can I improve performance when using oracle dbd? ... > Tim To ...
      (perl.dbi.users)