[Info-vax] Apache + mod_php performance

[Arne Vajhøj]

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