Have him update your DBI & DBD::Oracle to the latest versions.
(1.30) & (1.12)
On 03-Oct-2002 John-Thomas Beadles wrote:
> It's definite. I implemented it all through my code and dropped the
> execution time from 40+ minutes to approximately 4.5 minutes. I've notified
> the sys admin to the problem, see if we can implement a global solution.
> Thanks a bunch, guys!
>
> -----Original Message-----
> From: Beadles, John-Thomas [RICH1:2795:EXCH]
>
> Bingo, we have a winner! I've alternated including this statement, and it
> definitely appears to be the key, at least for this test code. Now I have
> to go modify my production code. I'll let you know if it works the same
> way.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> Ah yes, there was a bug in DBD::Oracle. I forget which version numbers, you
> can add my $foo = $sth->{NAME} before the $sth->execute which will start the
> caching. Which version of DBD::Oracle are you using?
>
----------------------------------
E-Mail: [EMAIL PROTECTED]
Date: 03-Oct-2002
Time: 15:29:23
----------------------------------
