On May 7, 2007, at 10:40 PM, Foo JH wrote:
My suspicion is that when you do a disconnect, the connection is
actually not released. That's the idea of connection pooling isn't it?
You can confirm this by checking the number of connections stated
on your sql server after a call.
Apache::DBI overload disconnect, so you never really disconnect.
Apache::DBI caches based on EXACT connection params. its not just
the same host/db -- its the entirety of connection options
( raiseerror , autocommit, etc )
so to answer your question:
use Apache::DBI ;
$db1= connect( A );
$db2= connect( A );
will both use the same handle.
use Apache::DBI ;
$db1= connect( A );
$db2= connect( A,B );
will both use different handles
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
