> 1 - Can different processes using the same login information > access this > cached database handle.
No, it has nothing to do with connection pooling or persistance between processes. It's merely a convienience method where, say, you might have two modules which both need a database connection, so you go ahead and do a 'my $dbh = DBI->connnect_cached(...)' in each one, and you're only actually connecting once (whichever makes the call first), and both are actually using the same handle. Of course, with something like mod_perl (with connect_cached or Apache::DBI), you end up with a persistent connection, but its all still within the same process. > 1a - In terms of efficiency, should different processes all > be using the > same statement handle? Different processes can't use the same statement handle. > 2 - I assume within a process that connect_cached does in fact return > the same connection for the same lookup based on arguments to it. Yep, but only within the same process. HTH, Douglas Wilson
