"Lasse Laursen" <laursen@stripped> wrote on 09/02/2005 13:24:27:
> Hi all!
>
> Simple question: What is fastest when doing a connection to a local
machine?
> TCP/IP or connecting via the socket? the application is a ACL helper
program
> under Squid which makes a persistent connection to the database (100
> parallel programs runs on the machine each connecting to the MySQL
database)
From the Connector/J documentation:
"Named pipes only work when connecting to a MySQL server on the same
physical machine as the one the JDBC driver is being used on. In simple
performance tests, it appears that named pipe access is between 30%-50%
faster than the standard TCP/IP access."
Alec Cawley