[PHP-users 353] Re: php4.0.6$B$H(BPostgerSQL$B$G$NF|K\8l%3!<%I$K$D$$$F!*(B

[$B>>Eh>MJ8(B]

--------------Boundary_0tM34a:OkH(AaSi
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

$B>>Eh!w(BITBoost $B$G$9!#(B
$BK\Bj$H$O$"$s$^$j4X78$J$$$G$9$,!#!#!#(B

| $B$\$/$O(BPHP4$B$O%$%s%9%H!<%k$O$7$F$k$1$I(B
| *.php$B%U%!%$%k$N%3!<%I$rFCJL$K0U<1$7$J$/$F$b(B
| $B$h$-$K7W$i$C$F$/$l$k$h$&$K$J$k$^$G$O(B
| PHP3$B$r;H$&$+$J$C$F46$8$G$9$1$I$M(B

$B?M$=$l$>$l$$$m$s$JA*Br4p=`$,$"$C$F$*$b$7$m$$$J$H$*$b$$$^$9!#(B

$B;d$N>l9g$O!"(B
 $BB.$$(B
 $B4X?t<+BN$,K-IY(B
 $B4X?tDj5A$H8F$S=P$7$O$I$C$A$,@h$G$b$h$$(B
$B$H$$$&M}M3$+$i!"(BPHP4 $B$r9%$s$G;H$&$h$&$K$7$F$$$^$9!#(B

$BMxMQ<T$NN)>l$G9M$($?$j!"%5%$%H$N=V4VE*$JMxMQ?t$d!"MxMQ(B
$B<T?t$N?-$S$rA[Dj$9$k$N$,Fq$7$$$3$H$r9M$($k$H!"B.EY$K(B
$B4X$7$F$O>/$7$G$bB.$$<BAu$r;H$$$?$$$H$3$m$G$9!#(B

# $B$b$A$m$s!"(BPHP $B$r;H$&$H$$$&A0Ds$"$j$-$G$NOC$G$9!#(B

$B$H$$$&$3$H$G!"<B:]E*$J46$8$G4JC1$JB,Dj$r$7(B PHP3 $B$H(B PHP4 
$B$NHf3S$r$7$F$_$^$7$?!#$4;29MDxEY$K!#(B

$BC;$$%9%/%j%W%H$G$9$,!"(BPostgreSQL $B$K@\B3$7!"A47o(B SELECT $B8e!"(B
$B%F!<%V%kI=<($9$k$H$$$&$b$N$G$9!#$h$/$"$k7A$@$H$*$b$$$^$9!#(B
$BN><TF1$8%9%/%j%W%H$G$9!#0l1~JRJ}$@$1E:IU$7$^$9!#(B

$B!A!A(B 500 $B%j%/%(%9%H$r;+$-$-$k$N$K$+$+$k;~4V(B $B!A!A(B

$B!z(B pg_pconnect $B;HMQ!'(B

  # killall -HUP httpd
  # ~mats/test/mylynx bench.php3
  --> 31.300251 sec.

  # cp bench.php3 bench.php
  # killall -HUP httpd
  # ~mats/test/mylynx bench.php
  --> 23.796615 sec.

$B!z(B pg_connect $B;HMQ!'(B

  # killall -HUP httpd
  # ~mats/test/mylynx bench.php3
  --> 38.042751 sec.

  # cp bench.php3 bench.php
  # killall -HUP httpd
  # ~mats/test/mylynx bench.php
  --> 30.488932 sec.

$B$$$m$s$J%*!<%P!<%X%C%I$r4^$s$G$$$^$9$N$G!"A4BN$N;~4V$N$&$A(B
PHP $B<+BN$N=hM}$N3d9g$ODc$$$+$H;W$$$^$9$,!"$=$l$G$b$3$l$@$1(B
$B:9$,$G$^$9!#(B

$B%F!<%V%k$O(B 5 columns x 67 rows $B$G$9!#(B

Apache $B$N@_Dj!JH4?h!K$O!"(B

  MinSpareServers 10
  MaxSpareServers 10
  StartServers 10
  MaxRequestsPerChild 0
  MaxKeepAliveRequests 100

$B$H$$$&46$8$G$9!#(B

mylynx $B%W%m%0%i%`$O(B thread $B$r(B 500 $B8D5/$3$7$F!"$=$l$>$l$,(B
lynx --dump http://localhost/... > /dev/null $B$r(B shell $B$+$i5/F0$9$k(B
C $B$N<+:n%W%m%0%i%`$G$9!#(B
$B>e5-$O$9$Y$F$N(B thread $B$r(B join $B$9$k$^$G$N;~4V$rB,Dj$7$F$$$^$9!#(B
$B2?2s$+$d$j$^$7$?$,!"$[$\F1$8$h$&$JCM$G$7$?!#(B

RedHat Linux 6.2J
PHP-3.0.15
PHP-4.0.3pl1
Apache/1.3.14 (Unix)
# $BA4It$,$A$g$C$H8E$/$F?=$7Lu$J$$$G$9!#(B

-- 
                                                      ,-------------+
+----------------------------------------------------'              |
| $B3t<02q<R(B IT Boost / $B%"%$%F%#!<%V!<%9%H(B                            |
| $B>>Eh(B $B>MJ8(B [ mats@itboost.co.jp ]                                  |
|                                         http://www.itboost.co.jp/ |
|         PHP, Perl, PostgreSQL, Apache, Java $BB>!"$$$m$$$m$"$j$^$9!#(B|
+-------------------------------------------------------------------+

--------------Boundary_0tM34a:OkH(AaSi
Content-Type: application/octet-stream; name="bench.php"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="bench.php"

PGh0bWw+DQo8aGVhZD4NCjx0aXRsZT5ob2dlPC90aXRsZT4NCjwvaGVhZD4NCjx0YWJsZT4N
Cg0KPD8NCiRjb24gPSBwZ19wY29ubmVjdCgiZGJuYW1lPW1hdHMgdXNlcj1wb3N0Z3JlcyIp
Ow0KDQokc3FsID0gInNlbGVjdCAqIGZyb20gZW1wbG95ZWUiOw0KJHIgPSBwZ19leGVjKCRj
b24sICRzcWwpOw0KDQokcm93ID0gcGdfbnVtcm93cygkcik7DQokY29sID0gcGdfbnVtZmll
bGRzKCRyKTsNCg0KZm9yICgkaT0wOyAkaTwkcm93OyAkaSsrICkgew0KICBwcmludCAiPHRy
PlxuIjsNCiAgZm9yKCAkaj0wOyAkajwkY29sOyAkaisrICkgew0KICAgIHByaW50ICI8dGQ+
IiAuIHBnX3Jlc3VsdCgkciwgJGksICRqKTsNCiAgfQ0KICBwcmludCAiPC90cj5cbiI7DQp9
DQo/Pg0KDQo8L3RhYmxlPg0KPC9ib2R5Pg0KPC9odG1sPg0K

--------------Boundary_0tM34a:OkH(AaSi--