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?
