ID: 30808
Updated by: [EMAIL PROTECTED]
Reported By: michael dot caplan at lechateau dot ca
Status: Suspended
Bug Type: OCI8 related
Operating System: RHE 3
PHP Version: 5.0.2
Assigned To: tony2001
New Comment:
Nope, mysql_connect() reconnects every time, as ociNlogon() does, so it
does not need to ping server.
ocilogon(), however, doesn't "reconnect" on every request, as this
operation in Oracle is rather slow, comparing with MySQL (you could try
to compare ociNlogon() vs ocilogon() speed and see the difference).
instead, it only creates new session, but server connection is stored
persistently and this causes your problem.
Previous Comments:
------------------------------------------------------------------------
[2004-11-18 17:59:18] michael dot caplan at lechateau dot ca
hi tony,
how does the mysql connect function handle this problem, or does it
ping the server each time?
------------------------------------------------------------------------
[2004-11-18 17:54:04] [EMAIL PROTECTED]
>And I don't see why a solution would necessarily depend on
pre-pinging.
I'd be glad to hear your proposal, Patrick.
------------------------------------------------------------------------
[2004-11-18 17:25:35] patrick dot lambert at noggin dot com
It would be great if this flaw in the OCI8
implementation could be resolved. It has been bugged
numerous times over the years. And I don't see why a
solution would necessarily depend on pre-pinging.
------------------------------------------------------------------------
[2004-11-18 16:59:38] michael dot caplan at lechateau dot ca
Ah, yes -- I suppose pinging every time would be a huge overhead. But,
how do other db supported by PHP (mysql for example) handle this issue?
I can most definately restart mysqld without needed to restart apache to
kill all my mysql persistant connections. The mysql library seams to
handle this without issue (or perhaps this is something that is
negotiated on the mysqld side)?
Also, perhaps I am miss understanding you, but you suggest that this
issue will be fixed in PDO OCI. If so, why cannot it be fixed in the
current OCI8 library?
Thanks,
Michael
------------------------------------------------------------------------
[2004-11-18 15:21:25] [EMAIL PROTECTED]
New ini option is needed because pinging every connection would lead to
huge overhead.
Your situation in fact is an exception, rather then a rule - most
people do not restart DB every day, so they would definitely not agree
with this slowdown.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/30808
--
Edit this bug report at http://bugs.php.net/?id=30808&edit=1
