Performance of Sockets vs. TCP/IP connections on localhost?
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) Regards -- Lasse Laursen · VP, Hosting Technology NetGroup Processing Aps Phone: +45 3370 1526 · Fax: +45 3313 0066 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Performance of Sockets vs. TCP/IP connections on localhost?
Lasse Laursen [EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]