Thread

1. Re: Connection pooling

   V. M. <txian@hotmail.com> — 2001-01-26T00:40:05Z

   Take a look to Apache::DBI
   
   bye
   valter
   
   
   >From: Frank Joerdens <frank@joerdens.de>
   >To: Gilles DAROLD <gilles@darold.net>
   >CC: pgsql-general <pgsql-general@postgresql.org>
   >Subject: Re: [GENERAL] Connection pooling
   >Date: Thu, 25 Jan 2001 20:57:33 +0100
   >
   >On Thu, Jan 25, 2001 at 05:14:50PM +0100, Gilles DAROLD wrote:
   > > Hi,
   > >
   > > With Apache/mod_perl it is very simple to enable DB connection
   > > persistance.
   > >
   > > in your perl script :
   > >
   > > use vars qw($dbh);
   > >
   > > $dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
   > >
   > > That create a persistance connection to your DB and you do not have to
   > > care
   > > about a pool of connection. Double pipe do all for you :-)
   > >
   > > But if you really want a pool just create an array of this kind of 
   >global
   > > var at startup
   > > and switch to any indices as you want.
   >
   >How's that supposed to work? Apache is a multi-process web server.
   >Connection pooling over all Apache children that are currently alive on
   >a web server would require some kind of inter-process communication,
   >which I don't think Apache supports (am I mistaken?).
   >
   >Regards, Frank
   
   _________________________________________________________________________
   Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
   
   
   

2. Re: Connection pooling

   Steve Leibel <stevel@bluetuna.com> — 2001-01-26T04:33:01Z

   At 1:40 AM +0100 1/26/01, Valter Mazzola wrote:
   
   >Take a look to Apache::DBI
   >
   >bye
   >valter
   >
   >
   >>From: Frank Joerdens <frank@joerdens.de>
   >>To: Gilles DAROLD <gilles@darold.net>
   >>CC: pgsql-general <pgsql-general@postgresql.org>
   >>Subject: Re: [GENERAL] Connection pooling
   >>Date: Thu, 25 Jan 2001 20:57:33 +0100
   >>
   >>On Thu, Jan 25, 2001 at 05:14:50PM +0100, Gilles DAROLD wrote:
   >> > Hi,
   >> >
   >> > With Apache/mod_perl it is very simple to enable DB connection
   >> > persistance.
   >> >
   >> > in your perl script :
   >> >
   >> > use vars qw($dbh);
   >> >
   >> > $dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
   >> >
   >> > That create a persistance connection to your DB and you do not have to
   >> > care
   >> > about a pool of connection. Double pipe do all for you :-)
   >> >
   >> > But if you really want a pool just create an array of this kind of global
   >> > var at startup
   >> > and switch to any indices as you want.
   >>
   >>How's that supposed to work? Apache is a multi-process web server.
   >>Connection pooling over all Apache children that are currently alive on
   >>a web server would require some kind of inter-process communication,
   >>which I don't think Apache supports (am I mistaken?).
   
   
   Apache::DBI provides persistent connections within each httpd child 
   process.  It does not do connection pooling across httpd children.