Pages: 123Next
Current Page: 1 of 3
PHPMyAdmin/ Mysql running very slow within Windows 8 - SOLVED!!!!
Posted by: tzhu07 (---.hsd1.wa.comcast.net)
Date: November 05, 2012 06:48PM

EDIT: Here's the solution originally posted by stevenmartin99:

"...host varirable in your mysql connection string.

mysql_connect("locahost".......

change to 127.0.0.1 and see if you get the 1 sec delay

...

if your finding phpmyadmin slow

in the config.inc.php you can change localhost to 127.0.0.1 also"


-----------------------------------------------------------------

I noticed that on pages that access the database, it takes about one second to load, whereas before it was instant on localhost. BTW, the pages look and function just fine. It's just that it's not instant load anymore.

I'm running wampServer on Windows 8. I wonder if that's the cause?

This is really irritating because I spam F5 like crazy during my coding sessions, and this issue just slows me down. Anyone experiencing the same issues?



Edited 8 time(s). Last edit at 02/08/2013 11:44PM by stevenmartin99.

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: spolen (---.neo.res.rr.com)
Date: November 05, 2012 06:57PM

I've never used wamp on windows 8, but I find that for me at least windows 8 is just generally slow.



Edited 1 time(s). Last edit at 11/05/2012 06:57PM by spolen.

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: musicjerm (70.102.169.---)
Date: November 08, 2012 10:08PM

I'm sorry, this isn't going to help much. I just wanted to share that I too am experiencing the exact same issue and it is quite frustrating. On top of this, I cannot access localhost or any vhost that directs to 127.0.0.1 in IE10. I can access 127.0.0.1 just fine but nothing else. It doesn't appear to be the hosts file either as I can for example connect to myproject.local if I have it pointing to another machine over the network or any other IP address. Again, this is just in IE10. Firefox and chrome seem to work just fine.

Edit: Also, I wanted to share that I did test this under ampps and experienced the same issue. So I do not believe it is related to wamp.



Edited 1 time(s). Last edit at 11/08/2012 10:09PM by musicjerm.

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: RiggsFolly (---.ppp.as43234.net)
Date: November 09, 2012 12:13AM

Some windows 8 system do not have a HOSTS file and those that do are not always very useful.


Check c:\windows\system32\drivers\etc is there a file called HOSTS in there (no extension )

If there is make sure it has a line like this in it:

127.0.0.1 locahost

if no file exists create one and add that line to it.

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: tzhu07 (---.hsd1.wa.comcast.net)
Date: November 09, 2012 10:49AM

RiggsFolly Wrote:
-------------------------------------------------------
> Some windows 8 system do not have a HOSTS file and
> those that do are not always very useful.
>
>
> Check c:\windows\system32\drivers\etc is there a
> file called HOSTS in there (no extension )
>
> If there is make sure it has a line like this in
> it:
>
> 127.0.0.1 locahost
>
> if no file exists create one and add that line to
> it.


I just checked. I do have that file and do have that line as well. Everything is in order with the hosts file.

Still don't know why it takes a whole second to load any page on localhost.

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: timonweb (---.dynamic.chello.pl)
Date: November 09, 2012 12:50PM

Mine is slow too, posted more details here: [forum.wampserver.com]

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: tzhu07 (---.hsd1.wa.comcast.net)
Date: November 09, 2012 08:28PM

timonweb Wrote:
-------------------------------------------------------
> Mine is slow too, posted more details here:
> [forum.wampserver.com]


Thanks! Let's bump each other's threads to really bring this to the fore-front attention.

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: tzhu07 (---.hsd1.wa.comcast.net)
Date: November 09, 2012 08:35PM

How do you even contact the WAMPserver guys? It'd be good if they were made aware of the issue.

Options: ReplyQuote
Re: PHP running very slow within Windows 8
Posted by: stevenmartin99 (Moderator)
Date: November 09, 2012 08:46PM

how about we dont bump it at all. its nothing to do with wamp, im going to merge these posts

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: musicjerm (70.102.169.---)
Date: November 03, 2012 03:32AM

I am getting the same issue. I also cannot access localhost (or vhosts) using IE10. I'm assuming this is a bug or compatibility issue with Windows 8.

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: kwacky1 (---.lns20.bne1.internode.on.net)
Date: November 03, 2012 01:01PM

same here, so painful to test anything in IE

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: tzhu07 (---.hsd1.wa.comcast.net)
Date: November 06, 2012 04:44AM

I'm having the same issue.

localhost is very slow. Pages are taking one second to load all the time, whereas before it was instant when I clicked around on my sites. I'm mostly a front-end developer, and unfortunately do not have in-depth knowledge of what could be happening. I'm on Windows 8 Pro.

BTW, wamp is so far the only program that I'm having trouble with on Windows 8. Everything else so far about the new OS has been great.



Edited 1 time(s). Last edit at 11/06/2012 04:49AM by tzhu07.

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: musicjerm (67.51.3.---)
Date: November 07, 2012 02:01AM

Is anyone else noticing that your vhosts will not work in IE10?

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: timonweb (---.dynamic.chello.pl)
Date: November 09, 2012 12:49PM

I do confirm too, that wamp is very slow on windows 8. Installed it yesterday and I'm really shocked: page wich previously generated in 500 ms (Windows 7, WAMP), now generates in 3000ms (Windows 8, WAMP), there is something wrong, either with php, apache or windows 8...

vhosts not working in IE10, I do confirm.

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: kwacky1 (---.lns20.bne4.internode.on.net)
Date: November 09, 2012 01:23PM

WAMP works fine in Google Chrome, IE10 is the only part giving me grief.

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: faguvenli (176.40.99.---)
Date: November 09, 2012 02:21PM

I tested phpinfo on windows 8 wamp 2.2 it opens instantly. so there is nothing wrong with the php.
But when I try to load a page which connects to mysql it slows down.
The waiting time changes. sometimes it takes 20 seconds to refresh the page.
I hope we can find a solution for this. This is so painful while coding and testing a new webpage sad smiley

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: faguvenli (176.40.99.---)
Date: November 09, 2012 02:27PM

I just tested mysql using the console. the queries work really fast. so there seems to be no problem with the mysql also.
Next thing to be tested is apache but I don't know what to do to test it.

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: kwacky1 (---.lns20.bne4.internode.on.net)
Date: November 09, 2012 02:31PM

This explains the same behavior that I'm getting.

[stackoverflow.com]

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: timonweb (---.dynamic.chello.pl)
Date: November 09, 2012 06:55PM

I develop in Drupal, so I changed 'localhost' to '127.0.0.1' in mysql connection settings and page load improved, now instead of 3000 ms it loads in 1500 ms, two times faster, but still not like in Windows 7 (it took 500 ms to generate a page in win 7). So there is some problem with localhost I guess.

Options: ReplyQuote
Re: WampServer is very slow on windows 8
Posted by: stevenmartin99 (Moderator)
Date: November 09, 2012 08:12PM

disable IPV6. thats all that is wrong here

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Pages: 123Next
Current Page: 1 of 3


Sorry, only registered users may post in this forum.