Joomla! Discussion Forums

I was surprised that I couldn't find a previous discussion of this anywhere in this performance forum, please redirect me if there's already been a discussion on this...

I've not used mysql extensively on Windows hosts, I have more experience with UNIX systems.  Traditionally I've preferred named pipe access to mysql from PHP for both performance and security reasons (when both are on the same box I mean).

On a host running Windows 2003 and IIS6, would experienced Joomla administrators recommend named pipe or localhost TCP/IP connections for mysql, and why?

Thanks in advance for any and all advice!

I run tcp/ip om my local site apache 2.058, mysql,4, php 5.20 windows xp pro on problems

I know you probably meant "no" problems, but just out of curiosity, did you make the decision to use TCP/IP versus named pipe access arbitrarily or for a reason?

I'm just curious, on all manners of UNIX where the httpd and the mysqld were on the same machine I've traditionally seen much better performance using named pipe access (plus one less security issue to worry about, since rather than 3306 only being available to 127.0.0.1 it's turned off entirely).  However there really doesn't seem to be much information out there about this on Windows (plus what little there is seems to contradict itself).

Thanks for any more clues.

default install of apache and mysql, php

The myth is TCP/IP is faster however, I've found that using the basic Named pipe is quicker. I was doing query speed comparison on both setups and I seemed to have almost a 25% quicker response on my named pipe rather than my tcp/ip setup. Anyone come up with the same thing?

Hi

And how do you use name pipe in joomla?