Re: [PHP-DB] oracle pooling

[email protected] (Christopher Jones)
Newsgroups php.db
Message-ID <[email protected]>

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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.