gil wrote:
>
> Hi,
>
> Is there any performance loss from accessing a local database using the
> remote syntax like this:
>
> my $local_database = 'DBI:mysql:truepath_db:www.truepath.com';
>
> Normally, I would say:
>
> my $local_database = 'DBI:mysql:truepath_db';
>
> Gil
> http://www.truepath.com
> your Christ-centered web host
It depends on your configuration of mysqld. The alternative syntax
using the host name will force the conection to be TCP/IP while the one
without the host name may use the Unix socket if mysqld is configured to
use one. Unix socket connection is about 7% faster than TCP/IP if I
remember correctly. So you should use 'DBI:mysql:truepath_db'.
--
Sasha Pachev
http://www.sashanet.com
