From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Deep integration of PostgreSQL with Apache |
Date: | 2005-05-04 00:04:22 |
Message-ID: | 6f2f2df333c92499a66b82b3483d0865@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200505020927
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFCdiqzvJuQZxSWSsgRAvmcAKC8HX5E/QwzhHalM0PNg/rMmufFhgCfZFlA
tt64Bin9lq7TFSSk/hCsYFg=
=Nmnq
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Randal L. Schwartz | 2005-05-04 00:30:06 | getting the ranks of items |
Previous Message | Mohan, Ross | 2005-05-03 23:17:30 | Re: Very interesting article about the future of databases |