RE: [PHP] Speed of MySQL connections - Socket vs. Non-Socket
| From: | Don Read | Date: | Tue, 17 Apr 2001 19:14:41 +0000 |
| Subject: | RE: [PHP] Speed of MySQL connections - Socket vs. Non-Socket | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49026@lists.php.net to get a copy of this message | ||
On 16-Apr-01 Alexander Skwar wrote:
> Hello!
>
> In a mysql_connect() it is possible to specify a path to the socket which
> should be used for communicating with MySQL.
>
> Now, when I connect thru a socket, is the datatransfer between PHP and MySQL
> faster than when I connect via a (loop-)network? I would assume so, because
> with a socket, there's not the network layer in the way which has to be
> taken care of.
>
> Is this correct?
>
Yes, from my memory of the mysql list; AF_INET is 7% slower then AF_UNIX in
data thru-put. Plus you have to add in the connection build & tear-down time.
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.