Re: Insert up to 200.000 with OCI Array?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 30 Sep 1999 08:35:16 -0400
Message-ID: <pFjzN+t4vMKG91OdBsp+WoNdTEui@4ax.com>

A copy of this was sent to "Antonio Pascual" <apa_at_jerez.micro.lucent.com> (if that email address didn't require changing) On Thu, 30 Sep 1999 09:37:14 +0200, you wrote:

>Anyone has inserted up to 200.000 records with OCI Arrays in one time?.
>How much time costs to the oexn function?.
>
>Thanks.
>
>Antonio.
>

In my experience, anything over about 100 records at a time starts to take *longer*.

The sweet spot (and YMMV) is around 100 records. It varies by the width of your record, your network and everthing else.

200,000 records at a time would definitely not be recommended. It would be slower then a much smaller size (and take heaps less RAM)...

--
See http://osi.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 Thu Sep 30 1999 - 07:35:16 CDT