Path: ...!news.mixmin.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Lawrence D'Oliveiro <ldo@nz.invalid>
Newsgroups: comp.os.vms
Subject: Re: Apache + mod_php performance
Date: Sat, 28 Sep 2024 01:54:11 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 25
Message-ID: <vd7nk3$12csp$1@dont-email.me>
References: <vcv0bl$39mnj$1@dont-email.me> <vd1bdp$3npm3$1@dont-email.me>
	<vd1lgd$dbq$1@reader1.panix.com> <vd1u8j$3qqpg$1@dont-email.me>
	<vd3vhj$849$1@reader1.panix.com> <vd6l5h$pmt5$1@dont-email.me>
	<vd7ec3$tdq8$4@dont-email.me> <vd7fdf$tgu3$1@dont-email.me>
	<vd7glq$tdq8$16@dont-email.me> <vd7hme$tgu3$3@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 28 Sep 2024 03:54:11 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="2132f4845d2292b1a04f05d8b30f9975";
	logging-data="1127321"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18vx4sogUPJNN2Mc8uu1L4Z"
User-Agent: Pan/0.160 (Toresk; )
Cancel-Lock: sha1:igB/9w+/Lfqp8U5iTBEhTDQU68g=
Bytes: 2139

On Fri, 27 Sep 2024 20:13:01 -0400, Arne Vajhøj wrote:

> On 9/27/2024 7:55 PM, Lawrence D'Oliveiro wrote:
>>
>> On Fri, 27 Sep 2024 19:34:07 -0400, Arne Vajhøj wrote:
>>>
>>> Sending SQL query from web server to database server over the network,
>>> having database server find data and sending data from database server
>>> to web server over the network takes time. Milliseconds.
>> 
>> You know we can use AF_UNIX sockets within the same machine, right?
> 
> If supported.
> 
> But in that case latency will be small. Microseconds.

Also loopback network connections should be similarly fast. It’s just that 
Unix sockets allow peers to verify each other’s identity, to shortcut 
authentication issues.

> But running application and database on same system is not an option if
> it is a high volume solution ...

Of course it’s an option. Performance is a tradeoff between conflicting 
system parameters.