Re: [PHP-DB] oracle pooling

2008-12-03 Thread Themis Vassiliadis
On Tue, Dec 2, 2008 at 6:16 PM, Christopher Jones [EMAIL PROTECTED] wrote: Themis Vassiliadis wrote: On Tue, Dec 2, 2008 at 4:18 PM, Christopher Jones [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Oracle 11g DRCP support is available in PHP. See this whitepaper:

Re: [PHP-DB] oracle pooling

2008-12-03 Thread Chris
DRCP is really a big improvement. But for me it has a great holdback: the pool controlled in the server side isn't defined for a specific schema, so if we have an application server serving different connections demanding different credentials certainly the performance will be worse. Another

Re: [PHP-DB] oracle pooling

2008-12-03 Thread Christopher Jones
Themis Vassiliadis wrote: DRCP is really a big improvement. But for me it has a great holdback: the pool controlled in the server side isn't defined for a specific schema, so if we have an application server serving different connections demanding different credentials certainly the

Re: [PHP-DB] oracle pooling

2008-12-02 Thread Themis Vassiliadis
That is greate. But for me it doesn't solve my problem because in may job we are working with 10G. I'm really thinking to develop the extension to do that. One more time, thank you very much for your help. Regards, -- Themis Vassiliadis On Mon, Dec 1, 2008 at 7:30 PM, Chris [EMAIL PROTECTED]

Re: [PHP-DB] oracle pooling

2008-12-02 Thread Themis Vassiliadis
On Tue, Dec 2, 2008 at 4:18 PM, Christopher Jones [EMAIL PROTECTED] wrote: 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

Re: [PHP-DB] oracle pooling

2008-12-02 Thread Christopher Jones
Themis Vassiliadis wrote: On Tue, Dec 2, 2008 at 4:18 PM, Christopher Jones [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: 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

Re: [PHP-DB] oracle pooling

2008-12-01 Thread Themis Vassiliadis
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. I made a draft PHP extension atablishing the pool between oracle and

Re: [PHP-DB] oracle pooling

2008-12-01 Thread Chris
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

Re: [PHP-DB] oracle pooling

2008-11-30 Thread Chris
Themis Vassiliadis wrote: Hi guys, I'm newer on this list. I'm looking for a extension to establish a connection pooling between server and oracle database. You could try sqlrelay (it has a php extension). Otherwise, 11g has connection pooling built in to oracle. For versions before that,

[PHP-DB] oracle pooling

2008-11-29 Thread Themis Vassiliadis
Hi guys, I'm newer on this list. I'm looking for a extension to establish a connection pooling between server and oracle database. I have tried using OCI persistent connections, but I'm convinced that control are very lake. My bigger challenger is to control max active connections upper limit