Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Many insertions at one shot

Re: Many insertions at one shot

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 30 Apr 2005 07:05:04 -0700
Message-ID: <NfudnfdxEp38De7fRVn-iQ@comcast.com>

"Patrice" <pat_at_noreply.com> wrote in message news:42733f9d$0$13660$79c14f64_at_nan-newsreader-05.noos.net...
> Hi,
> I am facing the following problem.
> I'm trying to make a high number of insertions into a remoteOracle
database
> from an EAI.
> My problem is: for 1000 records it takes around 10mns. That is too long
for
> me.
> Could you tell if it's possible by calling a stored procedure to send a
'n'
> number of records at one shot instead of inserting each record one after
> one.
> Thanks in advance for you help.
>
>
>

You don't need a stored procedure.
1. Use bind variables to insert.
2. Use the array interface to send 10 or 100 rows at a time.

It shouldn't take 10 minutes for 1,000 rows! Jim Received on Sat Apr 30 2005 - 09:05:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US