Which connection method is faster?

[Jon12345]

Let's assume you have mydomain1.com, which hosts a mysql db. The visitor is on mydomain1.com/index.php and this page adds data to this db.

Which method is faster in connecting to, adding to and updating a database (see examples below)?

$db=mysql_connect("localhost","user","pw");  

or

$db=mysql_connect("mydomain1.com","user","pw");  

Is there much different in speed between the two?

Thanks,

Jon

[bradgrafelman]

If the SQL server is located on the same server, I see no reason to use anything but localhost.

Using a domain name will probably tack on a little time just to do a DNS query only to find out that the IP returned points back to the server.

[scrupul0us]

localhost.... hands down... i dont allow mysql to allow connects from outside it... much more secure

[Sxooter]

Does mysql support local unix domain sockets (i.e. you don't include the name, and it defaults to using a local unix socket not TCP/IP). Those are much faster if they're supported.

[bradgrafelman]

It supports it, yes:

It can also include a port number. e.g. "hostname:port" or a path to a local socket e.g. ":/path/to/socket" for the localhost

By default, however, it uses a TCP port.