PHP slow with mysqli

Question

I (hope) this is a very straightforward question about what is being missed for PHP/MySQL. First, the computers are Windows 7 machines and are running XAMPP (Apache, PHP, MySQL, etc.) - nothing Windows/IIS, etc.

The machines are quick, with PHP & MySQL running super-fast. However, there is one machine where the way it works with PHP & MySQL is some kind of delay - specifically, it is essentially 3 seconds. In fact, if you remove EVERYTHING the code is doing so that it is doing NOTHING more than setting up its connection like this:

$db = new mysqli($hostname, $username, $password, $database);

...and there is no query or anything - just this PHP line that sets up the object, it takes exactly 3 seconds.

You comment out this line, by contrast, and the page is instant.

Anyway idea why this is happening? It doesn't look like anything is wrong, exactly, just somehow set up on this 3 seconds that we'd like to get rid of. Thanks!

Answer 1

If this is hosted locally and you are using localhost this will be your problem, try using

$db = new mysqli('127.0.0.1', $username, $password, $database);

This is because of how MYSQLI handles localhost and IPV6.