From: | Frank Joerdens <frank(at)joerdens(dot)de> |
---|---|
To: | Gilles DAROLD <gilles(at)darold(dot)net> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Connection pooling |
Date: | 2001-01-25 19:57:33 |
Message-ID: | 20010125205733.A15595@rakete.joerdens.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-01-25 20:02:34 | Re: beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ] |
Previous Message | Evelio Martinez | 2001-01-25 19:36:01 | PostgreSQL + PHP + SQL warning messages |