I am running a PHP MySQL application on Windows 2012 IIS, but it was extremely slow. Changing my db host from localhost:3306 to 127.0.0.1:3306 seem to do the trick. Any idea why?
The hosting company telling me that it is because the DNS lookup, but there is a difference of 7s. Could a DNS lookup take that long?