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 Alexander Skwar
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. Please read again what I wrote Alexander Skwar -- How to quote:

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

2001-04-16 Thread Brian Clark
Hi Alexander, @ 7:29:45 PM on 4/16/2001, Alexander Skwar wrote: ... > 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] > Now, when

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 documentat

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

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] >

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? Cer

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

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 Skwa

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 > be

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-)ne

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 (engl

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); > > > ?> > > s

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 'localhost:/tmp/mysql.sock