471,049 Members | 1,488 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Named pipe vs TCP/IP speed

Hi all,

I just noticed this in the manual yesterday:
http://www.mysql.com/doc/en/Windows_running.html

"MySQL supports TCP/IP on all Windows platforms. The mysqld-nt and
mysql-max-nt servers support named pipes on NT, 2000, and XP. The default is
to use TCP/IP regardless of the platform, because named pipes are actually
*slower* than TCP/IP ..."

This surprised me! I have been connecting with named pipes (and telling
others to do the same) on Win2k since I discovered them, because my queries
(and time to connect) are most definitely *faster*. The client/server
communication is about 25-30% slower using TCP/IP. Example: a simple SELECT
COUNT(*) FROM table takes 0.3ms with TCP/IP compared to only 0.16ms with
named pipes. Or, on a more complicated query, 2ms vs 1.5.

Speed differences seem comparable to Unix sockets vs TCP/IP on *nix.

Should the manual info be the other way around? If not, then why am I seeing
it that way? ;-) Any comments?

Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 5019

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Rajarshi Guha | last post: by
6 posts views Thread by Srijit Kumar Bhadra | last post: by
reply views Thread by Matt W | last post: by
5 posts views Thread by richard | last post: by
4 posts views Thread by Ken Allen | last post: by
3 posts views Thread by EricR | last post: by
2 posts views Thread by FB's .NET Dev PC | last post: by
reply views Thread by olaf.dietsche | last post: by
7 posts views Thread by andrewb | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.