RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-13 Thread Bauer, Jay W
: [PHP] Re: Understanding persistent connections with oci8 On Thu, October 12, 2006 1:21 pm, Bauer, Jay W wrote: > I agree and right now all there is in the way of tools for an > administrator to use within the PHP configuration is the number of > persistent connections per serve

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-13 Thread Bauer, Jay W
: Understanding persistent connections with oci8 On Thu, October 12, 2006 12:52 pm, Bauer, Jay W wrote: > Under the current situation these won't go away, unless there is a > lot of other traffic for the webserver and the httpd servers need to > free up these idle connections to handle

Re: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Google Kreme
On 12 Oct 2006, at 11:10 , Bauer, Jay W wrote: Again if someone is using this oci8.persistent_timeout they are using it because they want a way of controlling how long these connections stay around. Well, are they really? I would think they are using it to free up idle connections for use w

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Richard Lynch
On Thu, October 12, 2006 1:21 pm, Bauer, Jay W wrote: > I agree and right now all there is in the way of tools for an > administrator to use within the PHP configuration is the number of > persistent connections per server and the timeout interval. These are > a > bit crude as tools, but as the p

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Richard Lynch
On Thu, October 12, 2006 12:52 pm, Bauer, Jay W wrote: > Under the current situation these won't go away, unless there is a > lot > of other traffic for the webserver and the httpd servers need to free > up > these idle connections to handle other requests. But if there's no traffic, then does i

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Bauer, Jay W
eslund, Mikael; Bauer, Jay W Subject: RE: [PHP] Re: Understanding persistent connections with oci8 On Thu, October 12, 2006 12:10 pm, Bauer, Jay W wrote: > Again if someone is using this oci8.persistent_timeout they are using > it because they want a way of controlling how long the

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Bauer, Jay W
TED] Sent: Thursday, October 12, 2006 12:41 PM To: Bauer, Jay W Cc: php-general@lists.php.net; Mendonce, Kiran (STSD); Nikiel, Carsten; Rai, Moni (GSE WTEC Cupertino); Rieslund, Mikael; Bauer, Jay W Subject: RE: [PHP] Re: Understanding persistent connections with oci8 On Wed, October 11, 2006 3:

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Richard Lynch
On Thu, October 12, 2006 12:10 pm, Bauer, Jay W wrote: > Again if someone is using this oci8.persistent_timeout they are using > it because they want a way of controlling how long these connections > stay around. Actually, that's an over-simplification of the purpose of "persistent" and "timeout"

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Bauer, Jay W
ser [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 11, 2006 9:25 PM To: Bauer, Jay W Cc: [EMAIL PROTECTED]; php-general@lists.php.net; Mendonce, Kiran (STSD); Nikiel, Carsten; Rai, Moni (GSE WTEC Cupertino); Rieslund, Mikael; Bauer, Jay W Subject: Re: [PHP] Re: Understanding persistent connec

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-12 Thread Richard Lynch
On Wed, October 11, 2006 3:42 pm, Bauer, Jay W wrote: > From our testing of multiple connections we could easily create 50 > of > these persistent connections and would have to hit the apache web > server > pretty hard with a 1000 requests at 50 at a time to get these to > terminate after the tim

Re: [PHP] Re: Understanding persistent connections with oci8

2006-10-11 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-10-11 16:42:06 -0400: > And actually, Kiran in our lab proposed that as a very easy fix to > implement, and we've tested it and it works fine. In other words we > make 50 persistent connections, with the timeout at 10 seconds, wait a > minute and then make another roun

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-11 Thread Bauer, Jay W
ertino); Rieslund, Mikael Subject: RE: [PHP] Re: Understanding persistent connections with oci8 On Wed, October 11, 2006 8:46 am, Bauer, Jay W wrote: > Yes there have been some trigger-happy, bug-bogus-marking going on, > but that happens. > > And yes, this stays alive without anything

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-11 Thread Richard Lynch
On Wed, October 11, 2006 8:46 am, Bauer, Jay W wrote: > Yes there have been some trigger-happy, bug-bogus-marking going on, > but that happens. > > And yes, this stays alive without anything going on. And we have > tested your "other wrinkle" and that is how we have been able to end > the > pe

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-11 Thread Bauer, Jay W
-Original Message- From: Bauer, Jay W Sent: Wednesday, October 11, 2006 9:46 AM To: [EMAIL PROTECTED]; 'php-general@lists.php.net' Cc: '[EMAIL PROTECTED]'; Mendonce, Kiran (STSD); Nikiel, Carsten; Rai, Moni (GSE WTEC Cupertino); Rieslund, Mikael Subject: RE: [PHP] Re: Underst

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-11 Thread Bauer, Jay W
gards, Jay -Original Message- From: Richard Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 4:49 PM To: Bauer, Jay W Subject: RE: [PHP] Re: Understanding persistent connections with oci8 Excellent! Submit that to bugs.php.net, and you have very good odds that it won't g

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-10 Thread Bauer, Jay W
WTEC Engineer, Internet Services HP-UX Hewlett Packard Co. -Original Message- From: Richard Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 4:48 PM To: Mendonce, Kiran (STSD) Cc: php-general@lists.php.net Subject: RE: [PHP] Re: Understanding persistent connections with oci8 On Wed, Oc

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-09 Thread Mendonce, Kiran (STSD)
update the documentation so its more clearer to the end user ? Thanks and Regards, Kiran -Original Message- From: Mendonce, Kiran (STSD) Sent: Wednesday, October 04, 2006 10:34 AM To: php-general@lists.php.net Subject: RE: [PHP] Re: Understanding persistent connections with oci8 I understand

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-05 Thread Richard Lynch
On Wed, October 4, 2006 12:34 pm, Mendonce, Kiran (STSD) wrote: > I understand the performance boost one can get by reusing existing > connections. And I did see for myself that with the default settings, > oci_pconnect() does reuse all the connections. > > But what should happen if there are idle

RE: [PHP] Re: Understanding persistent connections with oci8

2006-10-04 Thread Mendonce, Kiran (STSD)
I understand the performance boost one can get by reusing existing connections. And I did see for myself that with the default settings, oci_pconnect() does reuse all the connections. But what should happen if there are idle connections and the timeout is reached ? That is my question. What is the