Re: Deep integration of PostgreSQL with Apache - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Deep integration of PostgreSQL with Apache
Date
Msg-id 6f2f2df333c92499a66b82b3483d0865@biglumber.com
Whole thread Raw
In response to Re: Deep integration of PostgreSQL with Apache  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I think the closest you are going to get is Apache::DBI however sense
> PostgreSQL is processed based you are going to get a new connection
> for every connection to Apache.
>
> On any reasonably busy site that can spell doom.

Actually, this is a classic argument for using mod_perl. Each Apache child
can connect once to the database, and stay connected as it serves requests
to different clients. There is very little overhead, and if you take advantage
of server-side prepares, things can run even faster.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200505020927
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCdiqzvJuQZxSWSsgRAvmcAKC8HX5E/QwzhHalM0PNg/rMmufFhgCfZFlA
tt64Bin9lq7TFSSk/hCsYFg=
=Nmnq
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: "Mohan, Ross"
Date:
Subject: Re: Very interesting article about the future of databases
Next
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: getting the ranks of items