Re: Apache + mod_php performance

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.