Re: Many insertions at one shot

"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.>>>

Also using bind variables and an array interface I easily can insert 1,000
rows in under a second.
Jim
Received on Sat Apr 30 2005 - 09:05:55 CDT