I am timing a simple query using PHP's microtime(true)
function before and after. The query is SELECT NOW()
and the execution time is 0.015625 seconds which is believe to be 15 milliseconds - this is far too long for such a basic query!
I know there is definitely something wrong with my setup, but I cannot seem to fix it.
I am running Windows Server 2008 R2 64-bit with PHP 5.4, MySQL 5.6 Server and IIS 7.5.
I have tried changing the host name to 127.0.0.1 and adding code to the hosts file, as well as modifying php.ini and my.ini - nothing seems to speed it up.