OCI: Is this a normal behavior?

From: Antonio Pascual <apa_at_jerez.micro.lucent.com>
Date: Fri, 6 Aug 1999 08:55:49 +0200
Message-ID: <7oe0sn$er8@nntpa.cb.lucent.com>

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?. Received on Fri Aug 06 1999 - 01:55:49 CDT