#1
  1. No Profile Picture
    xntrik
    Guest
    Devshed Newbie (0 - 499 posts)
    Getting a mysql connection in PHP takes 5 seconds. That's totally unacceptable. Why?

    BUT: today, the system being unchanged, it all worked in <1 second instead! Weird...

    I use PWS (IIS4) + NT 4 WS + PHP3.
  2. #2
  3. No Profile Picture
    nico
    Guest
    Devshed Newbie (0 - 499 posts)
    probably some VERY wrong settings?
    maybe it's NT that ****s up? i've been using php3+mysql under linux for ages and never had any speed complaints...
  4. #3
  5. No Profile Picture
    xntrik
    Guest
    Devshed Newbie (0 - 499 posts)
    I've found the pattern now; when the computer is offline, the MySQL connection takes 5 seconds. When it's dialed-up to the internet the connection goes rocket fast! REAL weird...

    Anyone got ideas? I'm confused.
  6. #4
  7. No Profile Picture
    HiFelix
    Guest
    Devshed Newbie (0 - 499 posts)
    Probably wrong setup of your DNS (see chapter 4.12.4 in the MySQL-manual). Try 127.0.0.1 instead of localhost.
  8. #5
  9. No Profile Picture
    nico
    Guest
    Devshed Newbie (0 - 499 posts)
    maybe you have something like "auto detect proxy settings" turned on? i just installed win2k and found that that option was on by default, which made it slow even if you connect to your local host...
    look at your internet settings or so (dont know what it is called in NT4)
    goodluck nico
  10. #6
  11. No Profile Picture
    xntrik
    Guest
    Devshed Newbie (0 - 499 posts)
    Thanks all, it was the DNS that caused the problem. I replaced all full name server requests with 127.0.0.1. It feels like something is not working right, but since both LAN, internet and everything on the local web server except PHP pages including MySQL access works great I'll leave it..

Similar Threads

  1. Check MySQL Version thru PHP
    By wolftrap1 in forum PHP Development
    Replies: 2
    Last Post: February 11th, 2004, 09:51 PM
  2. Replies: 5
    Last Post: February 11th, 2004, 03:18 AM
  3. Replies: 0
    Last Post: February 11th, 2004, 12:44 AM
  4. PHP 5 (MYSQL vs. SQLite)
    By ignition in forum PHP Development
    Replies: 1
    Last Post: January 23rd, 2004, 01:13 PM
  5. PHP Reconfig with mysql...
    By Legendary Fox in forum PHP Development
    Replies: 3
    Last Post: January 23rd, 2004, 12:46 AM

IMN logo majestic logo threadwatch logo seochat tools logo