Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #7347

Re: [newbie] Small question about FastCGI

Show all headers | View raw

On 10/23/2012 7:12 AM, Gilles wrote:
> Hello
>
> I just installed Lighttpd and mod_fastcgi to improve performance when
> running PHP scripts over CGI.
>
> Am I correct in understanding the following about what mod_fastcgi
> does:
> 1. loads severals instances of the PHP interpreter, each in its own
> process (hence the numerous instances of /usr/bin/php5-cgi in "ps aux"
> and the "php.socket-" pseudo-files in /tmp)
> 2. translates between HTTP requests/responses and the PHP scripts
> 3. does nothing about the PHP scripts, which are loaded, parsed,
> compiled, ran, and unloaded every time they are called
> ?
>
> I'm especially concerned about the last point: If I make a lot of
> calls to the database, does it mean that FastCGI doesn't provide
> persistent connections to it, so I'll have to investigate other ways
> to avoid opening/closing DB connections every time? Or is
> opening/closing DB connections a non-issue and the main issue is
> actual commands sent to the DB?
>
> Thank you.
>

Why do you think you need persistent connections?  Do you have a 
performance problem you've traced down to connecting to the database?

Persistent connections can improve performance in *very heavily* used 
websites (i.e. hundreds of hits per second), but also lock system 
resources even when the connections are not being used.

In most cases persistent connections will have little or no impact on 
performance, and can actually degrade performance (as well as causing 
other problems like having left-over data from the previous usage of the 
connection).

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

[newbie] Small question about FastCGI Gilles <nospam@nospam.com> - 2012-10-23 13:12 +0200
  Re: [newbie] Small question about FastCGI Jerry Stuckle <jstucklex@attglobal.net> - 2012-10-23 09:12 -0400
  Re: [newbie] Small question about FastCGI Michael Vilain <vilain@NOspamcop.net> - 2012-10-23 22:06 -0700
    Re: [newbie] Small question about FastCGI Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-10-24 20:49 +0200
      Re: [newbie] Small question about FastCGI Gilles <nospam@nospam.com> - 2012-10-25 13:04 +0200

csiph-web