> 1. What is the difference between working with PHP and MySQL on a local
> server and working with PHP and MySQL when MySQL is on a remote server

None in terms of functionality.

> 2. What is the protocol used to connect to MySQL on a local server and
> what is the protocol used to connect to a remote MySQL server?

On the local machine a client (PHP is a client) can connect through unix
sockets or TCP (3306). On a remote machine its TCP only. Unix sockets access
is faster than TCP.

> 3. Is there a difference in performance between connecting from PHP to
> MySQL on a remote server or PHP to MSSQL Server?

See above answer. Also you have any TCP/IP overhead to add on.

Regards

Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to