pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roberto Mello <rmello@cc.usu.edu>
To: Frank Joerdens <frank@joerdens.de>
Cc: Mathijs Brands <mathijs@ilse.nl>
Cc: pgsql-php@postgresql.org
Subject: Re: persistent connections, AOLserver (Was: [SQL] maybe Offtopic : PostgreSQL & PHP ?)
Date: Fri, 20 Apr 2001 10:31:41 -0600
Message-ID: <20010420103141.A20153@cc.usu.edu> (raw)
In-Reply-To: <20010418173727.A5021@rakete.joerdens.de>
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>
	<20010418085424.A13383@cc.usu.edu>
	<20010418173727.A5021@rakete.joerdens.de>

On Wed, Apr 18, 2001 at 05:37:27PM +0200, Frank Joerdens wrote:
> 
> Ah, very interesting indeed! I've been meaning to look into this for
> quite a while but never had the time to really play with it. Are you
> using PHP/AOLserver in a production environment? Did you have any
> problems, crashes, etc.? And, most importantly, how _does_ it work with
> persistent connections? Does AOLserver open a connection for each
> request/thread it creates? 

	I am not in production yet. Only development. As soon as I am further
down, I'll use ab to test how it handles high load.
	AOLserver itself opens a connection per thread, and it very
intelligently gives that same connection to other threads as they need it
and as soon as the curret one is done using it. It's lots faster than PHP.
	PHP running under AOLserver is another story. In that case AOLserver
does nothing to the connections, it just passes the requests to PHP and
let it deal with it. Since AOLserver is a single process, on which the PHP
module is running, my feeling is that the concurrency/transactions 
problem won't exist, since there are no child processes.
 
> AFAIK the problem is somehow rooted in the fact that PHP folks up until
> very recently used to have a strong MySQL bias, which doesn't (or
> didn't, until very recently) have proper transaction support. Hence they
> didn't really consider this scenario.

	Big mistake of the PHP team IMHO. I for one, didn't even consider using 
PHP due to their bias towards a clearly deficient product. It made PHP as
a whole look just as deficient.
 
	-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    
*^ *^                    <- Tribbles Praying



view thread (5+ messages)  latest in thread

Message-ID: <20010420103141.A20153@cc.usu.edu>
Permalink:  ../20010420103141.A20153@cc.usu.edu/
Also on:    postgresql.org/message-id/20010420103141.A20153@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, frank@joerdens.de, mathijs@ilse.nl, pgsql-php@postgresql.org
  Subject: Re: persistent connections, AOLserver (Was: [SQL] maybe Offtopic : PostgreSQL & PHP ?)
  In-Reply-To: <20010420103141.A20153@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