From: Roberto Mello <rmello@cc.usu.edu>
To: Mathijs Brands <mathijs@ilse.nl>
Cc: pgsql-sql@postgresql.org
Subject: Re: maybe Offtopic : PostgreSQL & PHP ?
Date: Wed, 18 Apr 2001 08:54:24 -0600
Message-ID: <20010418085424.A13383@cc.usu.edu> (raw)
In-Reply-To: <20010418164436.A41431@ilse.nl>
References: <B5CDCF382265D311BF33009027A8FE9401E6F3BC@pmrmsg.edsn.com>
<5.0.2.1.0.20010418223233.00a68170@mail.e-magine.com.au>
<20010418073430.B12408@cc.usu.edu>
<20010418164436.A41431@ilse.nl>
On Wed, Apr 18, 2001 at 04:44:36PM +0200, Mathijs Brands wrote:
> I've written several applications with Apache/PHP. At first I was using
> persistant connections, but I was soon forced to revert to normal db
> connects. The problem is the number of connections opened. If you have
> 50 Apache processes and 5 different databases, it is highly likely that
> you will end up (if you leave your application running long enough) with
> 250 persistant db links; not something pgsql really likes, unless you
> configure it to correctly handle large numbers of db links. Apache/PHP
> doesn't provide you with some way to pool connections :(
Ah, I see the problem. When you mentioned there were problems I
thought you were talking about the connections themselves.
I am using PHP 4 under AOLserver/OpenNSD, which has been fully
threaded from scratch (1994) so I hope this won't be much of an issue (but
then PHP 4 still has threading problems AFAIK).
Not using persistant connections is just too slow for me. It's
instantaneous for AOLserver to generate a page, when the same page with the
connection overhead in PHP takes A LOT longer.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
Tetris tagline: @@ o@o oooo @oo oo@
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, mathijs@ilse.nl
Subject: Re: maybe Offtopic : PostgreSQL & PHP ?
In-Reply-To: <20010418085424.A13383@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox