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

Report message to a moderator

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: 4589
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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Performance issue using OLE DB, need alternatives
Next Topic: PhpOracleAdmin - ie PhpMyAdmin
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 29 10:47:22 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.