Re: Apache + mod_php performance

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