News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Chris Jones' Blog:
PHP OCI8 and Oracle 11g DRCP Connection Pooling in Pictures
February 22, 2011 @ 10:44:46

Chris Jones has posted some "pictures" of the performance that an Oracle database sees when it uses the connection pooling versus the normal connect/allocate sort of connection with the Oracle OCI8 driver for PHP. As you can see, the differences in memory consumption are huge.

Here is a screen shot from a PHP OCI8 connection pooling demo that I like to run. It graphically shows how little database host memory is needed when using DRCP connection pooling with Oracle Database 11g. Migrating to DRCP can be as simple as starting the pool and changing the connection string in your PHP application.

He also describes the differences between the pooled and non-pooled connections (to the developer it's as easy as putting ":pooled" in the connect string) in his graphs, and notes that using the pooling doesn't just have to be for large site - smaller sites can benefit too.

0 comments voice your opinion now!
oci8 oracle connection pooling performance graph result


blog comments powered by Disqus

Similar Posts

Gennady Feldman's Blog: Installing Oracle Instant Client and making it work with PHP

PHP-GTK Community Site: The results of the 2007 IDE poll are in!

SitePoint PHP Blog: Discover Graph Databases with Neo4j and PHP

Chris Jones' Blog: PHP OCI8 Signal Handling and --enable-sigchild

PHPJack: Zend Framework's Future


Community Events

Don't see your event here?
Let us know!


opinion example extension laravel5 podcast api unittest community conference language voicesoftheelephpant laravel version interview php7 release introduction library framework series

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework