On Tue, Dec 2, 2008 at 4:18 PM, Christopher Jones <

> Chris wrote:
>> Themis Vassiliadis wrote:
>>> You are right but sqlrelay doesn't work on Windows plataform and the only
>>> possible solution from oracle to connect PHP using pooling is DRCP, just on
>>> 11G, but as far as I know it hasn't been implemented integrated with PHP.
>> All you have to do is change your TNS entry, nothing else.
>> http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-caching-pooling.html
>> Read the "Database Resident Connection Pooling" section.
> Oracle 11g DRCP support is available in PHP.  See this whitepaper:
> http://www.oracle.com/technology/tech/php/pdf/php-scalability-ha-twp.pdf
> Change the connection string slightly, and set one new php.ini parameter to
> use it.
> Chris
> --
> Email: [EMAIL PROTECTED]  Tel: +1 650 506 8630
> Twitter:  http://twitter.com/ghrd    Free PHP Book:
> http://tinyurl.com/f8jad

I think that DRCP is a work around solution. Of course is much better than
traditional connections as we had before 11G.

But I think that is really possible to develop a new extension working like
Java component Apache DBCP. This is a traditional pooling mechanism, where
is defined in a xml file the pooling description and it is ensured that just
applications behind Tomcat will use the pool.

So if imbedded in an extension, the pool will start just when apache starts,
and will down when apache stops. And the whole pooling definition will be at
the client side.

Pooling is a solution created for web applications, the DRCP, if I'm not
wrong, should be used from web and client applications like SQL Plus. They
just need to select the TNSNAME key and use the pool.

Themis Vassiliadis

Reply via email to