Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-17 Thread Christian Reiniger
On Tuesday 17 April 2001 02:10, you wrote: So sprach Brian Clark am Mon, Apr 16, 2001 at 08:01:04PM -0400: Ahhh, yes, I see that was stupid. Sorry, Alexander. :) Ah, thanks Joe for clearing up this confusion :)) Now that this is sorted out: What might be the best way to do some

RE: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-17 Thread Don Read
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?

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-17 Thread Alexander Skwar
So sprach Don Read am Tue, Apr 17, 2001 at 02:14:41PM -0500: 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. That's exactly what I'd expect. Hmm, so I take it, I should also ask on the

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-17 Thread Alexander Skwar
So sprach Christian Reiniger am Tue, Apr 17, 2001 at 02:01:48PM +0200: run "ab" (comes with apache) on two scripts, one using method A repeatedly, the other using method B repeatedly Thanks, will do. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-17 Thread Alexander Skwar
So sprach Don Read am Tue, Apr 17, 2001 at 05:13:14PM -0500: define('DBHOST', 'localhost'); // define('DBHOST', 'myhost.domain.com'); define('QRY', 'select * from foo'); $db=mysql_connect(DBHOST, DBUSER, DBPASS); if ( $db ) testquery(QRY); ? set the

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-17 Thread Alexander Skwar
So sprach Don Read am Tue, Apr 17, 2001 at 06:06:53PM -0500: I have with 3.0.18 installed (to match customers), 'localhost' will use the /tmp/mysql.sock. This may have changed under 4.x. Oh, yes, you are right! Thanks a lot - would have thought that I'd need to say

[PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread Alexander Skwar
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,

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread Brian Clark
Hi Alexander, @ 6:55:58 PM on 4/16/2001, Alexander Skwar wrote: ... In a mysql_connect() it is possible to specify a path to the socket which should be used for communicating with MySQL. Yes, it's in the documentation. int mysql_connect ([string hostname [:port] [:/path/to/socket]

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread eschmid+sic
On Tue, Apr 17, 2001 at 01:29:45AM +0200, Alexander Skwar wrote: So sprach Brian Clark am Mon, Apr 16, 2001 at 07:17:43PM -0400: In a mysql_connect() it is possible to specify a path to the socket which should be used for communicating with MySQL. Yes, it's in the documentation.

RE: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread Joe Sheble \(Wizaerd\)
Please read again what I wrote OK. In a mysql_connect() it is possible to specify a path to the socket which should be used for communicating with MySQL. Yes. [string hostname [:port] [:/path/to/socket] It's not a question. It is a statement prefecaing the real question, which

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread Brian Clark
Hi Joe, @ 8:04:08 PM on 4/16/2001, Joe Sheble (Wizaerd) wrote: ... In a mysql_connect() it is possible to specify a path to the socket ^^ which should be used for communicating with MySQL. Yes. [string hostname [:port] [:/path/to/socket] It's not a

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread Alexander Skwar
So sprach [EMAIL PROTECTED] am Tue, Apr 17, 2001 at 01:55:01AM +0200: I haven't to read the manual again. This is very well documented in the manual. If I remember correctly, I have put this lines into the PHP manual. Pardon me, but where is it very well documented what I asked about?

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread Alexander Skwar
So sprach Brian Clark am Mon, Apr 16, 2001 at 07:37:54PM -0400: In a mysql_connect() it is possible to specify a path to the socket which should be used for communicating with MySQL. Yes. [string hostname [:port] [:/path/to/socket] And again: There's no question in the sentence above, is

Re: [PHP] Speed of MySQL connections - Socket vs. Non-Socket

2001-04-16 Thread Alexander Skwar
So sprach Brian Clark am Mon, Apr 16, 2001 at 08:01:04PM -0400: Ahhh, yes, I see that was stupid. Sorry, Alexander. :) Ah, thanks Joe for clearing up this confusion :)) Now that this is sorted out: What might be the best way to do some benchmarking wrt. this? (Links are fine) Alexander