Array processing is not yet available, but don't underestimate the savings
available by preparing outside the loop and using bind variables. If you
don't do that, each time you execute the SQL, there are at least two extra
round trips on the network that could be avoided to describe and prepare the
SQL.
--
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: Friday, January 26, 2001 10:51 AM
Subject: Re: Oraperl, DBI,DBD , ARRAY PROCESSING and performance issue
> My program didn't use any bind variable, prepared statement.
> The BIND variable and prepared stmt definitely will speed up the program,
but without ARRAY proceccing,
> each sql*net trip takes about 50 ms.
>
> The best way to speed it up is to combine the trip using the ARRAY
processing feature.
> Is this feature availible in the new DBI,DBB perl ?
