From: LZW
Date: April 25 1999 10:42am
Subject: Re: Connection over network
List-Archive: http://lists.mysql.com/mysql/2342
Message-Id: <4.2.0.32.19990425032828.012b8b60@209.52.171.120>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

Hello!

I am a CGI programmer.  The Mysql server and CGI
scripts are running on the same machine.
I just wonder, if I move MySQL server to another
machine and let the CGI scripts establish connection
over network, will that be a performance gain or loss?
I believe that, for now, the CGI scripts talk to MySQL
via unix stream.  If I "split" them apart, they will
talk to each other via TCP/IP (correct me if I am wrong)
So there'd be a bigger overhead upon establishing connection
and the data transfer should be slower ... (am I right?)
But on the other hand, if MySQL has a dedicated server
to it, it can process queries a lot quicker.

I am on a 100MBPS LAN with very low network latency.

Does anyone has a suggestion or ideas?

Thanx :)

LZW