Very Slow Localhost config (Too slow too work)

I see I have “resurrected” an old topic quite well.

The references to other technologies have generally provided the same results for me.

At the end of the day I think we are dealing with a lot more overhead to run the server locally – even on my 10 core iMac ??

Please, if anyone does find the “magic bullet” on this speak up.

Thanks

@serafinnyc just an update, yesterday I changed my hosts file to use my computer’s IP address in place of 127.0.0.1 and really seems to have made a difference. I’ll see how it goes, but worth a try.

@jugle Thanks. I did that too and see no difference. I can’t figure it out.

…yesterday I changed my hosts file to …

I have read and heard that also. I tried it before and the change was quite marginal in my experience. I mainly work on a 10 core iMAC so the “potential” “horsepower” is there.

Taking a careful survey of the plugins I was / am using and being a bit more stringent about which, how and when to use them has made the most difference overall here.

I use several development plugins and some of those plugins are a bit “heavy”. Of course they aren’t necessary in a live environment. It’s that the performance is encumbered so during the development and production process locally that is my challenge.

The old tried and true advice is still true – that turning off plugins and testing, then turning on each plugin individually to the extent that it’s possible, tuning plugins on one at a time – observing performance as you go to carefully choose what ones “make the cut” – STILL TRUE.

This research is obviously important in dialing resource use. This is why the localhost is a “sandbox”

That’s always going to be true I think in the WordPress “ecosystem”.

Changing wp-config.php file with the following information does improve the speed.

in wp-config.php change from
define( ‘DB_HOST’, ‘localhost’ );
to
define( ‘DB_HOST’, ‘127.0.0.1’ );

Also some very cool and tricky part.

I installed the second WP but this time database was set to UTF8 instead of utf8mb4
I saw loads of improvement.

I am using Ampps since it has Softaculous and a cool control panel for fast local development.

Hi ezveryone,

i see that the post had been really active !

For now i just use Wamp for my projects and try to do the work with huge files before importing on local (compress manually with paint.net etc…)

For now i’m not good enough to write my own code so i have a use that is really “limited” by the default functionalities of my software

The only difference for me was going from Divi theme to Oxygen builder, i think everything is more light and the “construction” experience had been good if i remember right.

I planed on learning HTML, CSS and JavaScript, but that’s for later.

Maybe i’ll keep you guys updated when i reach that lvl (don’t know if the wp_memory needs will increase …

I think you should try to contact Wapm / Mamp / Xamp via mail to ask them if there are any tweaks out there that would allow you to have a stronger performances (i think it should be ok but would need to add a bit of code..), because i think that the main goal of those local hosting solutions was mainly to allow ppl to develop simple websites, and so i think that the litiations everyone is feeling come directly from the localhosting solution

• This reply was modified 4 years, 5 months ago by wilfriedsdv.

@risi Thanks that did the trick! Beautiful! I’m wondering if this means our host files aren’t correct then?

Unfortunately the changing the “Localhost” to the local IP doesn’t make a huge difference for everyone.

What has worked best for me is diligence with what, when and which plugins I use.

Thanks for the solutions above. I saved a lot of my time. I have a heavy site for which i have to test few features on local machine and above greatly replied many solution. Amazing.

• This reply was modified 4 years, 4 months ago by allenkanes.

I am using both Wampserver and WAMP.NET. On Wampserver, I did not notice slow mysql performance, while on WAMP.NET it is noticeable, but changing localhost to 127.0.0.1 solves the problem. I recommend trying WAMP.NET (on Windows) for simplicity of use, it is a real gem.

Update to my previous post: I was able to resolve slow server response time in Wampserver by updating all components (Apache from 2.4.43 to 2.4.46, mysql from 5.27 to 8.0.21, but it seems that updating PHP from 7.4.6 to 7.4.9 did the trick). I suspect that change of configuration perhaps new version of xdebug did speed the things up.
Previously I had 1500ms response time, which went down to ~50ms without xdebug. I also noticed that loading xdebug extension somewhat increases response time to 130 ms.

Whoa, thanks, @diondesigns. I’ve been using wp cli commands on my local Ubuntu box, and suffering slow reaction times (wp plugin list would take ~5 seconds, for example).

Changing localhost to 127.0.0.1 worked — my wp plugin list now returns in ~0.5 seconds.

I’m glad it works, though I’m not sure why it does…

Dion (@diondesigns)
1 year, 4 months ago
If this is a Windows box, go to your wp-config.php file and make sure DB_HOST is not localhost. Set it as follows:

define(‘DB_HOST’, ‘127.0.0.1’);

This tip solved my loading speed problem instantly. Thank you so much @diondesigns !

Put this in your local MU plugin

add_filter( 'pre_http_request', '__return_true', 100 );

Source

@wilfriedsdv
Hey
You can use Nginx server ( https://winnmp.wtriple.com/ ) in your local window machine, It will make your WordPress much faster
Nginx performance much better than apache(XAMMP or WAMP)