Path: ...!weretis.net!feeder9.news.weretis.net!panix!.POSTED.spitfire.i.gajendra.net!not-for-mail
From: cross@spitfire.i.gajendra.net (Dan Cross)
Newsgroups: comp.os.vms
Subject: Re: Apache + mod_php performance
Date: Tue, 24 Sep 2024 21:09:25 -0000 (UTC)
Organization: PANIX Public Access Internet and UNIX, NYC
Message-ID: <vcv9q5$ddb$1@reader1.panix.com>
References: <vcv0bl$39mnj$1@dont-email.me>
Injection-Date: Tue, 24 Sep 2024 21:09:25 -0000 (UTC)
Injection-Info: reader1.panix.com; posting-host="spitfire.i.gajendra.net:166.84.136.80";
	logging-data="13739"; mail-complaints-to="abuse@panix.com"
X-Newsreader: trn 4.0-test77 (Sep 1, 2010)
Originator: cross@spitfire.i.gajendra.net (Dan Cross)
Bytes: 1908
Lines: 32

In article <vcv0bl$39mnj$1@dont-email.me>,
Arne Vajhøj  <arne@vajhoej.dk> wrote:
>I am not impressed by Apache + mod_php performance on VMS.
>
>The basic numbers I see (simple PHP code for getting some data
>out of a MySQL database and displaying) are:
>
>Apache + CGI : 4 req/sec = 240 req/min
>Apache + mod_php : 11 req/sec = 660 req/min
>Tomcat + Quercus : 127 req/sec = 7620 req/min
>
>(VMS x86-64 9.2-2, Apache 2.4-58, Berryman PHP 8.1,
>Java 8u372, Tomcat 8.5-89, Quercus 4.0)
>
>That CGI is slow is no surprise. Using CGI for performance
>is like doing 100 meter crawl dressed in medieval armor.
>
>But I had expected much better numbers for mod_php. Instead
>of the actual x2.5 and x10 I had expected like x10 and x2.5
>between the three.
>
>Anyone having any ideas for why it is like this and what
>can be done about it?

Did you try running your test script under the PHP interpreter
directly, without the web stack?  What kind of QPS numbers do
you see if it's just PHP talking to MySQL?

With no further details, I'd wonder if you're not caching
connections to the database between queries.

	- Dan C.