Hi there guys, today I’m going to tell you a little trick on how to fix a problem which many of you coders have with windows 8.I had that problem too and I was very annoyed by the fact that PHP My Admin was working so slow almost 2 seconds delay, which is extremely slow.
I’m not sure why it has a 1 second delay for every query but I know how to fix this.Instead of using “localhost” on your connection to mysql, use “127.0.0.1” and you will get rid of the delay. For example :
$mysqli = new mysqli("127.0.0.1", "user", "password", "database");
Instead of this:
$mysqli = new mysqli("localhost", "user", "password", "database");
If you want to fix the delay on PHP My Admin you need to find this file and edit it ( xampp/phpMyAdmin/config.inc.php )
Add this line at the bottom of the page
$cfg['Servers'][$i]['host'] = '127.0.0.1';
And thats it, thanks for reading my tutorial and I hope it helps !