Path: eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: =?UTF-8?Q?Arne_Vajh=C3=B8j?= <arne@vajhoej.dk>
Newsgroups: comp.os.vms
Subject: Re: Apache + mod_php performance
Date: Fri, 27 Sep 2024 19:34:07 -0400
Organization: A noiseless patient Spider
Lines: 22
Message-ID: <vd7fdf$tgu3$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>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 28 Sep 2024 01:34:08 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="3910fcfe6957e3ff390434a9c1551702";
	logging-data="967619"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+WzzmsDEF7om9VHHQ+IfGO5jgyTA+wzUk="
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:m5mEfqi69PhqwCoZWshz3/jFuek=
Content-Language: en-US
In-Reply-To: <vd7ec3$tdq8$4@dont-email.me>

On 9/27/2024 7:16 PM, Lawrence D'Oliveiro wrote:
> On Fri, 27 Sep 2024 12:06:09 -0400, Arne Vajhøj wrote:
>> ... PHP scripts has significant latency
>> when interacting with external database so parallelization is a must.
> 
> I haven’t noticed such latency (albeit mainly with intranet apps written
> for an SME),

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.

>          but what I have noticed is getting the data with fewer
> queries is faster than getting the same data with more queries.

total latency from queries = number of queries * average latency of one 
query

It adds up.

Arne