Home » Open Source » Programming Interfaces » Php-Oracle pooling
Php-Oracle pooling [message #77003] Wed, 26 May 2004 05:18 Go to next message
Robert
Messages: 43
Registered: August 2000
Member
Hello,

we´re interested in using connection pooling in order to control the number of connections to database.
Now we use persistent connections with the ora_plogon() and OCIPLogon() function calls. Nevertheless, persistent connections do not scale as well as connection pooling. A persistent connection will be kept open for a process, but it will not allow connections to be shared between different processes.

Is there any solution (inside PHP or not) to implement pooling connection to Oracle?

We know tools like SQL-Relay, but how well this tool integrates for applications already deployed.

How we can limit the number of connections to Oracle?

Thanks a lot in advance.

Robert
Re: Php-Oracle pooling [message #77011 is a reply to message #77003] Sun, 06 June 2004 04:52 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Third party tools like SQL Relay (http://sqlrelay.sourceforge.net/) can be used to enable connection pooling for Oracle and other databases.

Best regards.

Frank
Re: Php-Oracle pooling [message #359163 is a reply to message #77011] Thu, 13 November 2008 23:37 Go to previous message
kmohan
Messages: 28
Registered: July 2005
Junior Member
You can use the latest OCI8 extension (1.3.4) and Oracle database 11g feature 'Database Resident Connection Pooling'. More here: http://www.oracle.com/technology/tech/php/pdf/php-scalability-ha-twp.pdf
Previous Topic: Performance issue using OLE DB, need alternatives
Next Topic: PhpOracleAdmin - ie PhpMyAdmin
Goto Forum:
  


Current Time: Thu Mar 28 18:25:10 CDT 2024