do not use localhost in config.php on Windows

[Swimmy]

$config['db']['host'] = '127.0.0.1'; // not 'localhost'

After suffering 1 second+ pages for more than a month, I made this simple change to the config.php file and page loads are 10x faster. For some reason having "localhost" adds a minimum of 1 second to EVERY page load. There is a huge difference in the user experience going form 1.08s to 0.08s.

It is completely reproducible. Switch to the ip address, site fast. Switch it back, site slow.

I know this has been mentioned in threads more than 1 year ago, but I didn't want to bump an old thread.

I am not a server expert...I am guessing it may have something to do with DNS lookup capability. There is a 1 second timeout happening somewhere if I use localhost.

 

[Paul B]

There's a previous discussion on it here: http://xenforo.com/community/threads/127-0-0-1-or-localhost.47329/

Also someone else noticed the same issue: http://xenforo.com/community/threads/slow-er-loading.42917/page-2#post-468104

 

[rdn]

Yeah, I'm using 127.0.0.1 also on my CentOS server.