RE: Persistent Connections to Oracle databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm



On 11 November 2004 19:11, Patrick David wrote:

> My understanding of persistent connections was that using the
> ociplogon function a connection would be opened to the
> database and all other connections to the same database (with
> the same username and password) would use the first one
> previously opened, which mean I would have only 1 connection
> to the database.

I know this is a late response, but I haven't seen anybody point this out
yet: that's 1 connection *per Apache child process*, since each process
still has to have its own connection.

>  But in fact it is not what is happening,
> every time I submit the page to the same database a new
> connection is opened. Which is a little bit annoying if I
> submit this one 100 times (100 connections at the end).

Potentially, if you have Apache configured to run 100 children or more.  If
you configure it to run only 50 children, that's the maximum number of
Oracle connections you will get.


Cheers!

Mike

---------------------------------------------------------------------
Mike Ford,  Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Headingley Campus, LEEDS,  LS6 3QS,  United Kingdom
Email: m.ford@xxxxxxxxxxxxxx
Tel: +44 113 283 2600 extn 4730      Fax:  +44 113 283 3211 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux