#1
  1. No Profile Picture
    xntrik
    Guest
    Devshed Newbie (0 - 499 posts)
    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...
  2. #2
  3. No Profile Picture
    Randy
    Guest
    Devshed Newbie (0 - 499 posts)
    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.
  4. #3
  5. No Profile Picture
    xntrik
    Guest
    Devshed Newbie (0 - 499 posts)
    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..

Similar Threads

  1. mysql and MS foxpro
    By wijbenga in forum MySQL Help
    Replies: 16
    Last Post: February 5th, 2004, 12:46 PM
  2. Replies: 0
    Last Post: December 30th, 2003, 01:57 PM
  3. mysql from a remote server
    By lobo78 in forum MySQL Help
    Replies: 8
    Last Post: December 24th, 2003, 08:53 AM
  4. mysql server on different machine than hosting
    By metro in forum MySQL Help
    Replies: 6
    Last Post: February 19th, 2003, 12:34 AM
  5. Replies: 4
    Last Post: August 17th, 2002, 03:42 AM

IMN logo majestic logo threadwatch logo seochat tools logo