November 24th, 1999, 01:33 PM
I recently posted my problems getting a mysql connection. I takes 4 seconds. But I just found out that when the computer is online to the internet (using modem) the response time from the mysql server is less than 1 second, including the query!
WHY is this?! So strange...
November 30th, 1999, 12:15 PM
Sounds like a DNS problem. Are you using the fully qualified domain name for the mysql server, or the ip address? Try using the IP address 127.0.0.1 to access it on your local machine.
December 1st, 1999, 12:14 PM
Thanks, that seems to be the problem. I used the full name for the server in the requests, but now replaced it with 127.0.0.1. It's working great now.
Not that I want to fix what is not broken, but I cant help wondering what's wrong with my DNS since everything in the LAN and on the internet works great, it's only MySQL access from a PHP page that's slow..