Re: OCI: Is this a normal behavior?

A copy of this was sent to "Antonio Pascual" <apa_at_jerez.micro.lucent.com> (if that email address didn't require changing) On Fri, 6 Aug 1999 08:55:49 +0200, you wrote:

>Hi all.
>Working with OCI, I have 2 programs to insert a lot of records in a table.
>The first program uses prepared statement ( bind one time and exec 1 time
>for record ).
> start
> parse
> bind
> for i = 1 to n
> Fill vars
> execute
> end for
> end
>
>The second program uses Array insertions ( bind one time, and exec one time
>passing to the funcion an array of structures ). This method must be faster
>than the other.
>
> start
> parse
> bind
> for i = 1 to n
> Fill array
> end for
> Execute passing the array
> end
>
>What happen is the following:
>When executes the programs several times, with the first method more or less
>the time
>consumed is the same, but with the second method vary very much between
>executions.
>Sometimes is faster than the first method and others it's the same, even
>other slower.
>
>Is this a normal behavior?.
>
>

do you see any "checkpoint not complete, cannot allocate new log" in your alert.log file on the server?

>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Aug 06 1999 - 07:34:43 CDT