[Info-vax] Apache + mod_php performance

[Arne Vajhøj]

On 9/24/2024 5:09 PM, Dan Cross wrote:
> In article <vcv0bl$39mnj$1 at dont-email.me>,
> Arne Vajhøj  <arne at 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?

Just executing the same PHP code in a loop give much higher
performance.

Single process : 158 executions per second = 9480 executions per minute

And multi process could probably get significantly higher.

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

Does not matter.

I just found out that Tomcat+Quercus numbers get even higher
after some warmup.

                     no db con pool    db con pool
Apache + CGI              4              N/A
Apache + mod_php         11               11
Tomcat + Quercus        208              214

Arne