Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3IEsju85103 for ; Wed, 18 Apr 2001 10:54:45 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f3IEsPtP013433; Wed, 18 Apr 2001 08:54:25 -0600 Date: Wed, 18 Apr 2001 08:54:24 -0600 From: Roberto Mello To: Mathijs Brands Cc: pgsql-sql@postgresql.org Subject: Re: maybe Offtopic : PostgreSQL & PHP ? Message-ID: <20010418085424.A13383@cc.usu.edu> References: <5.0.2.1.0.20010418223233.00a68170@mail.e-magine.com.au> <20010418073430.B12408@cc.usu.edu> <20010418164436.A41431@ilse.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: <20010418164436.A41431@ilse.nl>; from mathijs@ilse.nl on Wed, Apr 18, 2001 at 04:44:36PM +0200 X-Archive-Number: 200104/305 X-Sequence-Number: 2661 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@