pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Tetris tagline: @@  o@o  oooo  @oo  oo@  



view thread (6+ messages)  latest in thread

Message-ID: <20010418085424.A13383@cc.usu.edu>
Permalink:  ../20010418085424.A13383@cc.usu.edu/
Also on:    postgresql.org/message-id/20010418085424.A13383@cc.usu.edu

 · 

reply

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