RE: pool of DB connections ?

1999-11-29 Thread Sheth, Niraj
her server if you want or use as Unix Domain (as it's very fast compare to TCP/IP socket). Niraj -Original Message- From: Leslie Mikesell [mailto:[EMAIL PROTECTED]] Sent: Monday, November 29, 1999 11:00 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: pool of DB connection

RE: pool of DB connections ?

1999-11-29 Thread Chris Nokleberg
> So, Tim, what *are* the differences, and when should we should we > choose Apache::DBI vs DBI->connect_cached, and why? I think one of the big differences is that Apache::DBI overrides the disconnect method, to prevent accidentally calling disconnect from a mod_perl script. When using connect_

Re: pool of DB connections ?

1999-11-29 Thread Randal L. Schwartz
[watch the followups... this is going to both the modperl and the DBI list...] > "Ed" == Ed Park <[EMAIL PROTECTED]> writes: Ed> each creates a network connection to DBI::ProxyServer, which Ed> creates a few persistent connections to the db server using the Ed> connect_cached method. I had

Re: pool of DB connections ?

1999-11-29 Thread Matt Sergeant
On Mon, 29 Nov 1999, Oleg Bartunov wrote: > Hi, > > I'm using mod_perl, DBI, ApacheDBI and was quite happy > with persistent connections httpd<->postgres until I used > just one database. Currently I have 20 apache servers which > handle 20 connections to database. If I want to work with > anothe

Re: pool of DB connections ?

1999-11-29 Thread Leslie Mikesell
According to Oleg Bartunov: > > > Currently I have 20 apache servers which > > > handle 20 connections to database. If I want to work with > > > another database I have to create another 20 connections > > > with DB, so I will have 40 postgres backends. This is too much. > > I didn't write all de

RE: pool of DB connections ?

1999-11-29 Thread Ed Park
Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Oleg Bartunov > Sent: Monday, November 29, 1999 12:00 PM > To: Leslie Mikesell > Cc: [EMAIL PROTECTED] > Subject: Re: pool of DB connections ? > > > On Mon, 29 Nov 1999, Leslie Mikesell wrote: > >

RE: pool of DB connections ?

1999-11-29 Thread Oleg Bartunov
On Mon, 29 Nov 1999, Sheth, Niraj wrote: > Date: Mon, 29 Nov 1999 11:19:12 -0500 > From: "Sheth, Niraj " <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: pool of DB connections ? > > Have you looked at "Perl Co

Re: pool of DB connections ?

1999-11-29 Thread Oleg Bartunov
On Mon, 29 Nov 1999, Leslie Mikesell wrote: > Date: Mon, 29 Nov 1999 09:59:38 -0600 (CST) > From: Leslie Mikesell <[EMAIL PROTECTED]> > To: Oleg Bartunov <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: pool of DB connections ? > > According to Oleg Ba

Re: pool of DB connections ?

1999-11-29 Thread Leslie Mikesell
According to Oleg Bartunov: > I'm using mod_perl, DBI, ApacheDBI and was quite happy > with persistent connections httpd<->postgres until I used > just one database. Currently I have 20 apache servers which > handle 20 connections to database. If I want to work with > another database I have to c