Re: PHP + Oracle + OCIPLogon

On Wed, Jun 20, 2001 at 05:33:18PM +0200, Confuser wrote: > I understand that OCIPLogon creates a persitant connection to the Oracle DB, > to improve > performance... And I must say it does ! > > However, since OCILogoff is best not used with a persitant logon (and in the > latest versions, > it doesn't do anything anyway)... How will PHP decide when to cut that > connection loose ? one the connection is "broken" php will reestablish it. > > We are working on a relatively small website, with 4 users... Within no > time, the session limit > in Oracle (which is 60) is reached, and the site doesn't work anymore... if you MaxClients if set higher that the maximum number of session you allow in oracel than this would be true. remember: perstistent connection are on the apache-process level. so if you have 50 httpd processes running (and you use plogon) i would expect 60 active oracle connections! > > The website should be able to handle thousands of customers in the future, > so it would only > take a second to crash... not if you configure it "correct". believe me - there are ppls out there that use this stuff;-) tc