Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199908

Re: [PHP3] are Oracle persistent connections working? From: Alex Belits (abelits <email protected>)
Date: 08/10/99

On Tue, 10 Aug 1999, Phil Glatz wrote:

> but never seem to die. After a while, I have hundreds of connections, all
> idling, and driving the CPU load up. It is as if a new connection is being
> requested for each Apache page request, but the old ones linger on. If
> persistence was working properly, it seems the maximum number of Oracle
> connections to the web server would never exceed the server limit on child
> connections.
>
> So... am I doing something wrong? Are others using persistent connections
> successfully?

  There was a bug with exactly the same symptoms but PostgreSQL instead of
Oracle. Persistent connections were opened, but when another connection
was requested with the same parameters (from the same script or from
another invocation of script that had the same parameters), faulty
comparison procedure failed, and new connection was created again. It's
possible that the same problem exists in persistent connection
support for Oracle. I haven't looked at the Oracle code yet (sorry, busy
at work), but I remember that Postgres bug was rather tricky and involved
broken string length calculation. 

-- 
Alex

----------------------------------------------------------------------
 Excellent.. now give users the option to cut your hair you hippie!
                                                  -- Anonymous Coward

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>