Christopher Jones has a quick post with some information about a user group meeting happening in Brazil where the upcoming topic will cover the powerful combination of PHP and Oracle.

Elton Luís Minetto wrote to tell me that "PHPSC - a PHP user group of Santa Catarina in Brazil - is organizing an event dedicated to PHP that will take place at Chapeco on June 20." [...] He's presenting a session on PHP and Oracle, and will show some great results of using PHP's OCI8 with Oracle 11g connection pooling (DRCP).

The schedule for the event can be found here with details on which talks will be given when (including Elton's at 8am on the 21st.

Christopher Jones has pointed out a new whitepaper that's been published by oracle about the scalability the connection pooling affords for current versions of PHP.

The whitepaper talks about the changes in the PHP OCI8 1.3 extension, explains some of the concepts behind DRCP and FAN, and gives best practices and tuning tips. It includes a new PHP benchmark which shows up to 20,000 connections being handled by Oracle on commodity hardware using only 2G RAM.

The paper also talks about the FAN support that's built in - the ability for PHP to use the Oracle RAC cluster functionality to make for high availability (switching between nodes). The latest beta with all of this functionality in it can be grabbed from its page on the PECL site.

Christopher Jones has posted an announcement about the latest release of the PECL OCI8 package (version 1.3.2 Beta) hitting the streets:

I've released PECL OCI8 1.3.2 Beta - the latest release of PHP's OCI8 extension with support for Connection Pooling and Fast Application Notification. The release is based on the current PHP 5.3 development branch.

He notes another change in this release - a "session release" bit of functionality persistent connections will do when nothing is referencing them anymore, mking them work a bit more like normal connections. Issues that could be caused by this can be corrected with a new setting (oci8.old_oci_close_semantics) in your php.ini.

Christopher Jones has pointed out a new customer interview that was done covering PHP and the connection pooling in Oracle 11g for Oracle Magazine.

Oracle Magazine's May/June 2008 issue contains a "Developer Nation" article. In it, David Kelly interviews Levi Dixon from Community Connect about using PHP and Oracle.

The article references the Oracle/PHP "strange combination" that used to exist and how it's evolved into a vital, living part of Oracle's stack (like with the OCI8 extension).

In this new post to his Oracle blog, Christopher Jones mentions some updates he's made to the OCI8 extension for PHP:

I've merged connection pooling (DRCP) and Fast Application Notification (FAN) support to PHP 5.3's OCI8 extension. The PHP 5.3 OCI8 code is Beta - in fact, PHP 5.3 itself is still really "Development". (It would be handy to have problems reported before PHP 5.3 goes Production).

He also includes instructions on how to get this new version installed inside of the latest PHP 5.3 snapshot (http://snaps.php.net) to build the new support in.

In a new post to his blog, Christopher Jones mentions some of the talks that he's going to give at the upcoming Zend/PHP Conference & Expo:

Oracle & PHP users: make sure you check out the Zend Conference. I'll be given a couple of sessions, "Connection Pooling & Other Features for Data Scaling" and "Performance Tuning for PHP with Oracle Databases". There are plenty of other great talks, too.

There's tons of other sessions happening during the conference including talks on:

• best practices
• enterprise PHP
• the Zend Framework
• API design

Check out the official conference page for information on location, other sessions and registration.

On his blog today, Christopher Jones hands the floor off to Luxi Chidambaran to talk some about "Highly Scalable Connection Pooling in PHP".

Oracle Database Resident Connection Pooling - a connection pooling feature in the next version of the Oracle DB that will allow very high traffic web sites to scale better. We announced this feature at Oracle OpenWorld in 2006. One cool thing about the feature is that it is not just limited to PHP - any database client could use it.

Luxi talks about pooling in general, pooling database connections specifically, how Oracle handles it and the three views around it - DBA, Client side, and the PHP user views.

Hot on the heels of this announcement, Andi Gutmans has posted some of his thoughts on this new functionality and how it can help companies both large and small (he mentions specifically Yahoo! of course).

In my experience, databases have had a long history of being the typical bottleneck in PHP applications. There are many reasons for that.

His reasons include the fact that web apps being heavily database driven, PHP developers would rather write PHP than SQL, and that there's a lack of good, cheap tools to help find these bottlenecks. What he focuses on most, though, is the overhead caused by the need for multi-process environments to force each process to manage their own connections to the databse.

He talks about some stats on average connections and application speed, about efforts IBM has made to help the situation, and how it's not necessarily just the server's fault for delegating out the database resources - why can't they all adapt?

According to this new post on Chrisopher Jones' blog, Oracle has listened to it's PHP users and is implementing something in the 11g version of their database they've been asking for for a while - connection pooling.

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.

They're also looking to add an attribute into the php.ini file to see whether or not the server needs to disconnect at the end of an oci_close or not. Stay tuned for more information as it comes up about this cool new functionality.