At the end of my Oracle Develop conference presentation today, I handed over to a key contributer to Oracle's PHP effort for this news:
Today at the "PHP/Oracle Experience: Building for Scalability" talk at Oracle Develop, Luxi Chidambaran announced a new Oracle Database 11g feature: Database Resident Connection Pooling. This feature allows multiple middle tiers to share the same connection pool and provides improved scalability for Oracle customers. The new feature will be available through Oracle's Call Interface API (OCI).
Chidambaran also proposed changes to PHP's OCI8 extension to take advantage of Database Resident Connection Pooling. PHP/Oracle users have had connection pooling high on their feature request list.
Chidambaran also proposed changes to PHP's OCI8 extension to take advantage of Database Resident Connection Pooling. PHP/Oracle users have had connection pooling high on their feature request list.
I have asked Luxi to write up the technical details from his presentation. Stay tuned. We are looking for input from OCI8 users about the potential changes. The current plan is to add one new php.ini parameter and make oci_close() release persistent connection resources for reuse in the pool.
We're interested in how users might configure and use the connection pool in PHP and other tools. This will directly influence the configurability vs complexity of PHP's OCI8 implementation.
Note: Oracle 11g is not yet in production.
--
Update: Luxi's write up is at http://blogs.oracle.com/opal/2007/01/03
Comments (4)
Great News for Oracle/PHP Developers
Posted by Paweł Barut | October 25, 2006 3:08 AM
Posted on October 25, 2006 03:08
sounds great! we have been needing this for 3 years. we use Oracle 9i (moving to 10g), PHP, Apache and RedHat Linux. is there any third party application that would preform the connection pooling until 11g is released?
nice site!
Rich
Posted by Rich | November 10, 2006 10:59 AM
Posted on November 10, 2006 10:59
There is a 3th party opensource around called sqlrelay (sqlrelay.sourceforge.net).
I haven't tried it myself though
Posted by Bogguard | April 30, 2007 5:02 AM
Posted on April 30, 2007 05:02
I know customer who use and those who decided against SQL Relay. Any comments on it would be welcome.
Posted by Christopher Jones | April 30, 2007 2:09 PM
Posted on April 30, 2007 14:09