I have been doing a little research into connection Pooling with OCI and I was just wondering if the concept of a "Connection Pool" would fit into the DBI spec someplace.

As we already have DBI::Apache and "connect_cache" would it just be redundant to add this "connect_pool" as the present functionality can be 'Bent' to that way?

Say something like this

$DBI->connect_pool($pool_name,$data_source,$username, $password,$min_connections,$max_connections,\%attr);

The idea being one could create two separate pools at the Apache level one for lets say "Read_only_Users" and one for "Read_Write_Users" and use connections out of the pool.

Or am I just creating something that no-one else will use??

cheers
John Scoels

Reply via email to