ID: 11614
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Closed
Bug Type: OCI8 related
Operating System: windows 2000
PHP Version: 4.0.5
New Comment:
Sorry, but the idea of persistent connection is to keep only "one" and
the "same" connection to the database as long as the parameters are the
same, isn't it ?
>>ThreadsPerChild 3
What does it mean? Does PHP open a persistent connection for each
Thread? Why can't be only one connection for all threads? Inter-process
serialization problems ?
Cristiano.
Previous Comments:
------------------------------------------------------------------------
[2001-06-22 06:38:06] [EMAIL PROTECTED]
I think I've found a really valid explanation:
Christopher Ostmo <[EMAIL PROTECTED]> told me
"the connections are actually persistent, which
means that you will in fact benefit. The down side is that you are not
going to always get the same persistent connection for each request"
and finally I understood:
to be sure, I've set
ThreadsPerChild 3
in my httpd.conf and now get a maximum of 3 persistent connections to
oracle; (this is just an explanation for someone who thinks to have the
same problem...)
this simply means you have to estimate and configure web&oracle server
for the worst case (maximum number of conn.)
--Giuse
(I think this can be quickly closed)
------------------------------------------------------------------------
[2001-06-22 05:50:10] [EMAIL PROTECTED]
<?php
$conn = ociplogon('user','pass','testdb');
echo "Server Version: " . OCIServerVersion($conn);
?>
reloading the same page I get ever more connections;
you can check it with:
select * from v$session where status ='ACTIVE'
-----------------
oracle version is:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
web server:
Apache 1.3.12, with php running as a module
the only active module in php.ini is oci8.dll;
-----------------------
(
the php manual, chapt.22 says :
When a persistent connection is requested, PHP checks if there's
already an identical persistent connection (that remained open from
earlier) - and if it exists, it uses it. If it does not exist, it
creates the link.
)
is this related to apache's multithreaded behaviour on windows?
--Giuse
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=11614&edit=1
