Localhost rendering pages are very slow

Question

My localhost rendering pages were slow. Everything even simple html rendering was taking around 2-5 seconds. I researched on it and got it fixed by replacing:

new \PDO(... ':host=localhost' ...);

to

new \PDO(... ':host=127.0.0.1' ...);

can anyone explain to me or give me a link to read why localhost was slowing down and how just changing it into IP made it very fast. Right now it renders even complex queries less than a second when it was taking around 5-10 seconds before.

And also is there any security issue by replacing localhost with IP? I mean if i host my project live and i replace localhost with the IP of the host will it have affect on any kind of security?

thanks alot

The only difference is the time it took to resolve localhost to `127.0.0.1`. — Anirudh Ramanathan, Feb 09 '13 at 21:36
you mean like it took localhost as a string and started to lookup for IP that corresponds to localhost and thats the time that it needed to search? — GGio, Feb 09 '13 at 21:37
See also $host=gethostbyname('localhost') at http://stackoverflow.com/a/16233679/1854563 — Gunnar Bernstein, Apr 28 '14 at 08:14

score 3 · Accepted Answer · answered Feb 09 '13 at 21:39

3

I reckon this could have something to do with IPv6 being enable on the server where you run your script. I'm not very strong on network topics, but such issue has been discussed several times.

I looked for an article that could give a better explanation, I think I found one: MySQL and Localhost Performance (it's from 2011, but it still applies in many cases).

answered Feb 09 '13 at 21:39

Diego

7,312
5
31
38

Had the same issue and the situation in the link helped. Thanks :) . – Radu Murzea Apr 15 '13 at 15:03

score 2 · Answer 2 · answered Oct 22 '13 at 08:49

2

The solution that worked for me was to edit httpd.conf and disable the loading of the CGI module by commenting this line:

LoadModule cgi_module modules/mod_cgi.so

Commenting would be just adding a # in front, like this:

#LoadModule cgi_module modules/mod_cgi.so

Restart the Apache service and you should be good to go.

answered Oct 22 '13 at 08:49

noname

1,268
1
16
21

Helped fix my slow localhost. Tried everything else and nothing worked but this did – AdRock Nov 14 '13 at 10:10

Localhost rendering pages are very slow

2 Answers2