--- Tim Bunce <[EMAIL PROTECTED]> wrote:
> [deleted]
> $dbh->{Driver}->{CachedKids}
> [deleted]
> Tim.
Thanks Tim. That really threw me off -- but it
worked!
I was expecting to find information on all handles in
the DBI, and not any one of the handles. But thanks,
it did work and now I have the option of using it.
Unfortunately, since I can't tell if the handle's
connection was reused vs. re-established I will still
have to set my NLS environment after the
$dbh->connection_cached.
I also ran some performance tests comparing Option 1)
if(! $dbh->ping) {reconnect & establish NLS
environment}, OR Option 2) always connect_cached &
always establish NLS environment. On my Celeron
333/with local Oracle, option 1 was 2.6 milliseconds
while option 2 was 6.4 milliseconds (after the initial
connection). That's a pretty small difference so I
think I will leave the code as it is (option 2).
Thanks, Tom
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
