Re: Persistent Connections in Webserver Environment

On 02.05.2005 17:41, Scott Marlowe wrote:

> But if the average PHP script takes 50 milliseconds to start up and 100 milliseconds to run, then either one is still
prettymuch noise. 

Yeah, _IF_ :)
Our scripts reside precompiled in a bytecode cache so there just isn't
much start up time ;)

I just replaced the simple query with a real world one:

http://hannes.imos.net/real_world.txt

http://hannes.imos.net/pconnect.php
http://hannes.imos.net/connect.php

Refresh both a few times to get meaningful result.

Still factor 3-4. And this is one of the most complex queries we have --
and factor 3-4 just makes a differece for us :)

> Plus, neither benchmark is interesting really until you have pretty good parallel load running.

The scripts are on a production box with decent load.

> It may well be that pconnect makes a difference under heavier load.  But most the time, I've seen one or two queries
thatcould be tuned make a much larger difference than using pconnect. 

We allways try to optimize and get most of performance from a query
anyway :)

> And, if you haven't got apache / postgresql configured properly and run out of connections, the connect time goes
from16 mS to hours as your users wait for you to fix the connectivity issues.  :)  

True, but we will test high load and will make sure that this won't
happen :)


--
imos  Gesellschaft fuer Internet-Marketing und Online-Services mbH
Alfons-Feifel-Str. 9 // D-73037 Goeppingen  // Stauferpark Ost
Tel: 07161 93339-14 // Fax: 07161 93339-99 // Internet: www.imos.net