Speeding up Drupal on Vista with Wampserver

Submitted by Frederic Marand on

The problem : Drupal awfully slow on Vista (and Seven) with Wampserver

For some time now, I'd been severiously annoyed by the (utter lack of) performance of Drupal 6 and 7 on my home PC, which happens to be running Microsoft Vista: considering I was used to getting page times around 200ms on a fractional Celeron with Apache 2.2 on a Linux server hosted comparatively far across the net from that same machine, I felt the 5 to 15 seconds response time per page on this local machine with a quad core and 3 GB RAM were really making me lose my time.

The solution

After some time spend googling around, I stumbled upon an incredibly simple tip, which made the 5 to 15 seconds per page drop down to around 1 second when logged in, and well below 500 ms when not logged in. It's incredible what ONE single character in a plain text file gets you under Vista :-)

UPDATE 2010-01-23: David Hogg tells us (see below) that this works for Windows Seven too

So, without further ado, here is this little gem : add a sharp character ('#') as the first character of the line containing: ::1 localhost in your c:\Windows\System32\drivers\etc\hosts and save it. If your machine is anything like mine, your Drupal response times should all of a sudden be divided by a factor between 5 and 10.

More detail

What this smallish change does is remove IPv6 localhost resolution from the hosts file. It is likely to cause other problematic situations if you do any IPv6 work, of course, and then you'll probably want to dig deeper into your network and/or Apache config.

Can't write to the hosts file ?

The mandatory access control feature of Windows Vista prevents normal programs from touching this file, even when you are logged in to an administrator account with all privileges. This means that your favorite text editor will load the file read-only and be unable to save your changes. To prevent this from happening, you must start the editor as Administrator. Unless you disabled it, the UAC window will ask you for confirmation, which you will have to give to your editor instance. After that, you will be able to edit the hosts file normally.

Kim Stewart (not verified)

Sun, 2009-01-18 01:57

Thanks!!!

I changed
"::1             localhost"
to
"#::1             localhost"

in C:\Windows\System32\drivers\etc\hosts

and it worked like a charm for me in Vista!!!

hello,

there is no line ::1 localhost on my host file. furthermore, even if I start notepad with the admin rights, I still can't save the files.

Could you help me, please?

Regards,
Xavier

I'm afraid I don't have a clue: unless you (or some other person or software) tampered with your OS install, that line should be there. Also, starting an editor with admin rights (which doesn't just mean start it from an admin account) should allow you to save the hosts file (not host, is it a typo ?) back.

Maybe you have some so-called "security" software installed, which prevents you from administering your system ?

Frederic Marand

Thu, 2009-09-24 20:24

In reply to by Anonymous (not verified)

Commenting the normal 127.0.0.1 localhost entry shouldn't do you any good, quite the contrary.

The only point of this change, and only on Vista, is to disable a non-operational IPv6 resolution for localhost, but 127.0.0.1 is an IPv4 address.

David Hogg (not verified)

Wed, 2010-01-20 18:59

Installed the latest Acquia Drupal stack on my 64 bit windows 7 machine. Worked - but very slow response. Your one character fix worked like a charm! Thanks.

Has anyone had any luck installing eAccelerator with DAMP on XP or Vista ? This should speed some things up as well, but I haven't yet located a windows version of the latest release of eAccelerator (0.9.6) to use with PHP Version 5.2.13.

eAccelerator, like APC, is an opcode cache, which saves time by not-reparsing PHP code on every page. This is really unrelated to the issue mentioned here, which is about the delays caused by non-optimal IPv6 (mis-)configuration, not about PHP itself.

Wozzle (not verified)

Wed, 2010-12-29 01:28

My host file already had the hash mark before the mentioned line.

guess I will just have to abandon local Drupal dev and do it on a server.

I have read many thousands of lines on this subject but not a working fix in site.

:(

Frederic Marand

Wed, 2010-12-29 10:09

In reply to by Wozzle (not verified)

I still use Windows to run Adobe CS5, as well as some business apps without a Linux equivalent, but for all dev work, I run on Linux. At work, it's on one LAMP Samba server (really an older PC I no longer use) with Zend Studio on my Windows box working on the files on the server, and at home or on my laptop, I just dual-boot into Ubuntu: then everything falls into place; Studio is faster, every Linux tool I'm using is there, and so on.

Some would advocate virtualization, but I tend to find that every serious work session uses just about any last percent of the resources of the non-virtualized machine, so I would not recommend this. OTOH, most of my projects implement not just LAMP but also Memcached, MongoDB and Varnish, because they are tied to larger customer projects, which is probably not completely typical in terms of hardware requirements. As you may have noticed, many Drupal devs tend to use Apple Mac, which gives them the benefit of an efficient Unix+AMP stack combined with top design tools (meaning especially CS5 for design and Omnigraffle for diagrams).

But, eventually, you can even get decent Drupal performance on Vista/Seven too: just use WIMP (IIS instead of Apache) instead of WAMPserver, possibly from the Zend Server Community Edition, and by all means tune your MySQL server: most Windows distributions use MySQL settings totally inappropriate to Drupal work.

Jock Munro (not verified)

Fri, 2012-08-17 11:56

Hi,

I just wanted to say that turning off Ipv6 using the settings suggested in this blog helped my problem greatly reducing 30 secs refresh at times during development to around 10-15. I had tried everything suggested that I could find and had resigned myself to the fact that I was just going to have to live with the 15 secs it took for my PC to reload/refresh as I develop.

My laptop is quite a high spec dual core and the processors and ram very rarely hit 100% so I couldn't understand why I was getting such poor performance with Wampserver.

Last week I swapped out my HDD hard drive for a SSD solid state drive and I can't believe how fast my laptop is now. Page refreshes that previously took 30 secs and timeouts now take 2-5 secs. Absolutely brilliant. For an outlay of £160 for a 256 gb ssd I really couldn't be happier. Added benefit is Windows loading/shutdown takes about a third of the time too. It's like having a new laptop.

Certainly worth considering if you have tried all the other tweaks first.

Cheers