Re: INSERT performance

From: Noel <noel_mckinney_at_ieee.org>
Date: Tue, 7 Nov 2000 23:26:38 -0600
Message-ID: <8uao33$q0u$1@nntp9.atl.mindspring.net>

<mao_guang_at_my-deja.com> wrote in message news:8uad97$ji1$1_at_nnrp1.deja.com...
> Hi, all:
>
> I want to improve the performance of INSERT performance of my Pro C
> program.However,i have no knowledge of this field,so i have to do
> commit every 5 times.I know it is ugly,could anyone do me a favor ?
>
> Regards
>
> Mao Guang
>

Do your INSERT using host arrays instead of inserting one-at-a-time with host variables. That way you can have a single call to Oracle that does multiple INSERTs.

Noel Received on Tue Nov 07 2000 - 23:26:38 CST