Re: [GENERAL] Perl - Apache / Postgress

> Erik Colson wrote:
>
> I'm using Apache with mod_perl to access a PostgresSQL database (6.5)
> .
>
> The script starts with connecting to the database... this means that
> the server is actually reconnecting everytime the script starts and
> disconnect when the HTML page is generated.
>
> I've read about a possibility to make a 'permanent' connection to the
> database ? Can anyone tell how ?

I've never used mod_perl, but I use FastCGI with CGI.pm, and that works
just great. In the CGI script you have a loop


<Connect to database>
while (my $q = new CGI::Fast) {
  <Handle CGI requests>
}

and this works just fine. The Apache fastCGI module is available from
www.fastcgi.com.

Adriaan