Link to home
Start Free TrialLog in
Avatar of eyal_barouk
eyal_barouk

asked on

Connecting mysql from windows 2003 web

Hi,
I have:
PHP, IIS on Windows 2003 web edition on one machine.
and on a different machine I have MYSQL.

Other applications on different servers (not web servers) connect to the MYSQL machine with no problem - it is very fast to respond.
Ever since I have upgraded my web server to windows 2003 web I am experiencing very slow connection between it and the MYSQL server.
This happens with the thinest queries I run and with no users load on the web server.
On a web request the web server is very fast to respond but it takes it more than 40 seconds to get anything from MYSQL.

Please help.
What should I check?
Thanks!
Avatar of eyal_barouk
eyal_barouk

ASKER

Plus: The PHP command that actually takes all this time to run is:

mysql_connect($server, $un ,$pass );
ASKER CERTIFIED SOLUTION
Avatar of Raynard7
Raynard7

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Oh man!
skip-name-resolve did it big time. It is working so fast now!

Are there any security issues I should be aware of by using this skip?
Not particularly - it just means that you will be storing ip addresses rather than domains; it should not make much of a difference - as if someone is spoofing ip's going to the dns would still return the same result regardless.