Do you have AutoCommit = 0?
Are you using bind variables?
Did you prepare the SQL outside your loop?
How many indexes do you have on the table while inserting?
--
Mac :})
** I may forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Ted X Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 6:27 AM
Subject: Oraperl, DBI,DBD , ARRAY PROCESSING and performance issue
> I'm looking for some help to spped up my perl application.
>
> It's a data loading program written in Oraperl, perl5.02.
>
> Each morning, we need to load about 50,000 records into the oracle
database.
>
> The problem is that the oraperl have no way ( not to my knowledge) to do
array processing. so the application does50,000 times sql call to the
databasen. Each call takes about 60ms, so the whole loading program takes
about an
> hour, which is too long.
>
> Can anyboy tell me how I can use the ARRAY processing feature in ORAPERL
or just PERL ?
