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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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.
ASKER
mysql_connect($server, $un ,$pass );