Monday, June 29, 2009

host wildcard % not working for machine names, only IPs

host wildcard % not working for machine names, only IPs
Posted by: Dewey Gaedcke ()
Date: June 21, 2007 02:19PM

I know you can create a wildcard "grant" for local subnet IP's by '192.168.%.%' or all IP's by '%', but this syntax is NOT working when the local subnet resolves as the individual machine name that's trying to connect.
Example: hostname='myPCname' so mysql sees the connection coming from:
username@myPCname instead of username@
even though they are one and the same address on the subnet

How do you create a wildcard grant that works for all the unique developer machine names that need to connect when they are on a local windows network and the IP is not used???

This is frustrating---all advice appreciated!!
I don't know how MySQL does the reverse IP lookup. But if it uses the hosts file first, you could try to add a line like
to /etc/hosts so that the name resolves to the similar IP and vice versa.

Sunday, June 28, 2009

What is the difference between MySQL server replication and SQLyog synchronization

What is the difference between MySQL server replication and SQLyog synchronization?

Technically they are completely different. MySQL server replication basically operates in the way that the server defined as the 'slave' reads the binary log of the 'master' and replicates operations performed by the master. SQLyog/SJA synchronization uses SQL to query the servers, compares the data using advanced checksum algorithms and performs the INSERTS, UPDATES and DELETES needed to bring databases in sync.

Both methods have their advantages and drawbacks. The most important aspect in favour of the method used by SQLyog synchronization is, that it is possible even if one or both of the databases are in a "shared environment" such as an ISP. You don't need any special privileges to use SQLyog synchronization - only simple SELECT, INSERT, UPDATE and DELETE privileges. And you won't need your own dedicated hardware.

When the SQLyog Job Agent (SJA) connects to the databases that should be synchronized, it does so as any client does. There is no downtime for other users/connections and all data are available for other users while the sync process is running. In that respect SQL server replication and SQLyog synchronization are similar. And as far as the end result goes: having identical databases (if that was what you specified) at both servers they are identical.

What are the differences between Database synchronization and replication

What are the differences between Database synchronization and replication?
Posted by: Pervasync Software ()
Date: January 02, 2009 04:14PM

Database synchronization is closely related to database replication. In fact, sometimes people use the terms interchangeably. However, there are big differences, understanding which will help us understand the different approaches used for solving replication and synchronization problems.

Replication is mostly used in situations where identical replicas of the complete data set are maintained on two or more database instances for high availability and performance reasons. Database instances can often work independently as backups for each other. The relationships between the instances are equal, symmetric. Normally the number of DB instances is small.

On the other hand, in a database synchronization system, typically you have a big central database on the server side and a large number of small databases each residing on a device. The central database contains data for all the devices while each device’s local database only contains the device’s private data and some shared data.

In the non-database world, Synchronization is also often used to describe the data exchange between a more temporal sub-set of data and a more persistent full-set of data. For instance, parts of a file could be buffered in-memory by an operating system and are “synchronized” with the file on hard disk. Another example is the synchronization of the data in a CPU cache memory with the data in the main memory.

Pervasync Software

Replication and synchronization

Replication and synchronization happen to be something about which I
know a teensy weensy little bit. :-) So I'll toss in my 2 cents'

The easiest thing to implement is the current proposal: one writable
master, and many read-only slaves. Anything that allows writes at
multiple locations is fraught with difficulty. There are a number of
well-known solutions, but all of them have drawbacks, and most require
some complexity.

Multiple-write replication schemes fall into two broad categories:
conservative and optimistic. Briefly, conservative approaches seek to
ensure that there will never be "conflicting" writes (what Nicolas
Fischer called "collisions"). The master/slave method mentioned above
falls into the conservative category. Another popular and relatively
simple conservative approach is the "voting" scheme. Before writing
any record, the writer first contacts a majority of other replicas,
and sets locks on the record. Then it does the write and releases the
locks, propagating the new record as part of the lock-release
message. Clearly, only one writer can lock any record at any time.
Furthermore, if a writer has an out-of-date copy of the record, he can
find out as part of setting the lock.

The disadvantage of this and most other conservative approaches is
that they require a majority of the replicas to be online at any given
time. The voting scheme can be modified slightly by assigning weights
to replicas; a more reliable replica will get a heavier weight, and to
lock you only need to get a majority of the weights.

The one-writable-master scheme can also be modified so that instead of
doing writes directly at the master, a slave first locks the record at
the master, then updates it locally and sends the updated version to
the master. If it chooses, the master can then notify all other
slaves of the new value. This approach is handy if it's important
that all slaves be kept up to date. Many multiprocessor computers use
a form of this approach to keep their caches consistent between

There are also overhead issues with locking schemes. The number of
messages exchanged can be excessive in some circumstances.

In optimistic approaches, by contrast, every replica accepts writes
without considering the possibility of conflicts. At some later date,
replicas "gossip" with each other to tell each other about updates.
As long as there's no conflict, everything is fine. Otherwise, some
sort of conflict-resolution scheme must be invoked. An early paper
on the idea was titled "Apologizing vs. Asking Permission", which is a
nice summary of the difference between the two methods.

Optimistic approaches can work very well when conflicts are rare. I
suspect that they would be rare in MusicBrainz once it was past the
initial stage of populating the database. However, implementing an
optimistic approach is probably more difficult than doing a
pessimistic one, especially when you consider the work of resolving

I've only touched the surface of a complex subject here, but I hope my
comments will help to serve as a starting point for further
Geoff Kuenning geoff at

Software, like bridges, should be elegant and visually pleasing as
well as functional. Ugly constructs, designs, and languages should be
avoided like the plague.

Synchronization Replication Mirroring

Synchronization (PeerSync’s default mode) - files added or updated on the source PC are copied to the target PC or storage device.

Replication - same as "Standard synchronization" (files added or updated on the source PC are copied to the target PC or storage device) and any files on target that do not have a matching source file are deleted (if you delete a file on the source, it will be deleted on the target).

Mirroring – A term often used synonymously with Synchronization.

Error Code: 2006 - MySQL server has gone away

"Error Code: 2006 - MySQL server has gone away"

I think the most likely reason is that the (server) max_allowed_packet setting is too low compared to the size of BULK inserts in the file.

Old server versions dispaly only that in this situation. 5.0.41 say "got a package too big" or something like that!

Thanks that was exactly the problem. Followed the instructions below

In Linux:

Copy the my-xxx.cnf file from /usr/share/mysql to /etc as my.cnf

xxx can be small, medium, large, huge ... depending on the requirement.

$ cp /usr/share/mysql/my-xxx.cnf /etc/my.cnf

In the my.cnf file, change the default
max_allowed_packet = 1M
max_allowed_packet = 16M

Save the file and restart MySQL server.

In Windows:

In the MySQL server installation directory,
in my.ini file, add the following line under [mysqld] in SERVER SECTION.

max_allowed_packet = 16M

Save the file and restart MySQL server.








三口劍 : 我在想當初創作混沌之弓的深意究竟是什麼
月神 : 不就是絕心忘情,登峰造極,這是代代月神的悲傷宿命,幸好,我已經擺脫了
三口劍 : 我想不是,為混沌之弓,甘願赴死的那群前輩,他們投身那火爐的那一刻絕不是抱著怨恨的心情,他們的犧牲絕不是為了讓代代月神繼續承受悲傷的宿命
月神 : 那是為什麼
三口劍 : 混沌之弓的真意就是成全
月神 : 成全,那是什麼意思,師父不是這樣教我的
三口劍 : 妳的師父教錯了,混沌之弓的真意是為了停止悲傷,為了讓別人永不再悲傷,犧牲自己的幸福,讓他人幸福,這就是成全
月神 : 為什麼要這麼做,人不是自私的動物嗎,為什麼要別人犧牲自己
三口劍 : 妳也感覺我自私嗎
月神 : 你與他們不同
三口劍 : 這個世界上有很多願意為別人犧牲自己的人
月神 : 我不懂,我也不想懂:這太複雜了.......



真正的高手,內心都有自吾修練的 定 (沉穩 內歛)

真正的高手,內心都有自吾修練的 定 (沉穩 內歛)

Saturday, June 27, 2009
































































人生某個角度來說是一個無法回頭的單行道, 一旦走到下一個階段,就不在會對前一階
段的 事情太過關心,也不太有興趣談論。
























































「那這個又是誰? 」我指著另一團他漫畫中比較小的爛泥說





























































php utf-8


$conn = mssql_connect( "MyServer2k", "user", "password" );
mssql_select_db('testing', $conn);

$query = "select top 10 * from member2";
$result = mssql_query( $query );

while( $row = mssql_fetch_array( $result ) ) {
//echo strtoupper(ucs2toutf8($row['title']))."<br>";
//echo iconv('UCS-2LE', 'UTF-8', $row['title'])."<br>";
$title = $row['note2'];
//$whichcode = mb_detect_encoding( $row['title'], "auto" );
//$whichcode = is_utf8( $row['title'] );

//$title = mb_convert_encoding( $row['title'], "UTF-8", "UCS-2LE" );

//$title = preg_replace("/([\xE0-\xFA])/e","chr(215).chr(ord(\${1})-80)",$title);

//$title = iconv( "", "UTF-8", $title );

//$title = ucs2html( $title );

echo $title."<br>";

echo "code: ".$whichcode;

function is_utf8($string) {

// From
return preg_match('%^(?:
[\x09\x0A\x0D\x20-\x7E] # ASCII
| [\xC2-\xDF][\x80-\xBF] # non-overlong 2-byte
| \xE0[\xA0-\xBF][\x80-\xBF] # excluding overlongs
| [\xE1-\xEC\xEE\xEF][\x80-\xBF]{2} # straight 3-byte
| \xED[\x80-\x9F][\x80-\xBF] # excluding surrogates
| \xF0[\x90-\xBF][\x80-\xBF]{2} # planes 1-3
| [\xF1-\xF3][\x80-\xBF]{3} # planes 4-15
| \xF4[\x80-\x8F][\x80-\xBF]{2} # plane 16
)*$%xs', $string);

} // function is_utf8

function ucs2toutf8($str)
for ($i=0;$i < strlen($str);$i+=4)
$substring1 = $str[$i].$str[$i+1];
$substring2 = $str[$i+2].$str[$i+3];

if ($substring1 == "00")
$byte1 = "";
$byte2 = $substring2;
$substring = $substring1.$substring2;
$byte1 = dechex(192+(hexdec($substring)/64));
$byte2 = dechex(128+(hexdec($substring)%64));
$utf8 .= $byte1.$byte2;
return $utf8;
function CP1251toUTF8($string){
$out = '';
for ($i = 0; $i < strlen($string); ++$i){
$ch = ord($string{$i});
if ($ch < 0x80) $out .= chr($ch);
if ($ch >= 0xC0)
if ($ch < 0xF0)
$out .= "\xD0".chr(0x90 + $ch - 0xC0); // А-Я, а-п (A-YA, a-p)
else $out .= "\xD1".chr(0x80 + $ch - 0xF0); // р-я (r-ya)
case 0xA8: $out .= "\xD0\x81"; break; // YO
case 0xB8: $out .= "\xD1\x91"; break; // yo
// ukrainian
case 0xA1: $out .= "\xD0\x8E"; break; // Ў (U)
case 0xA2: $out .= "\xD1\x9E"; break; // ў (u)
case 0xAA: $out .= "\xD0\x84"; break; // Є (e)
case 0xAF: $out .= "\xD0\x87"; break; // Ї (I..)
case 0xB2: $out .= "\xD0\x86"; break; // I (I)
case 0xB3: $out .= "\xD1\x96"; break; // i (i)
case 0xBA: $out .= "\xD1\x94"; break; // є (e)
case 0xBF: $out .= "\xD1\x97"; break; // ї (i..)
// chuvashian
case 0x8C: $out .= "\xD3\x90"; break; // Ӑ (A)
case 0x8D: $out .= "\xD3\x96"; break; // Ӗ (E)
case 0x8E: $out .= "\xD2\xAA"; break; // Ҫ (SCH)
case 0x8F: $out .= "\xD3\xB2"; break; // Ӳ (U)
case 0x9C: $out .= "\xD3\x91"; break; // ӑ (a)
case 0x9D: $out .= "\xD3\x97"; break; // ӗ (e)
case 0x9E: $out .= "\xD2\xAB"; break; // ҫ (sch)
case 0x9F: $out .= "\xD3\xB3"; break; // ӳ (u)
return $out;

function ucs2html($str) {
$str=trim($str); // if you are reading from file
for($i=0;$i < $len;$i+=2)


Dell可以提供特惠價 + coupon
變成 3999 但送 1000元*3 coupon (三個月期,下次購物才能使用,買萬抵千)

除了19" 20" LCD外,那天訂22"、23"、 筆電、桌電的人應該也不少
而不會被訂19" 20" LCD的人批評說差別待遇



這才是聰明人的做法. 這樣事情處理掉了, 還變向廣告搶同行生意...

Friday, June 26, 2009

















念研究所,許多人都覺得光是上課指定教材都讀不完了,哪有空在看其他書。可是我除了開學科的指定教材外,還會去找老師指定教材外的所有課外參考書目。如果圖書館有,那一定印,而且不只如此,我還去蒐集沒有要修的課的教材和指定教材參考教材。甚至到最後,只要是該領域的相關圖書,無論中英文,有的就印就買。有空就拿出來翻讀。那段歲月,甚是瘋狂。甚至迷上某些英文出版社的書系,瘋狂的收集購買,像是sage的tcs系列就是我的心頭好。Routliedge 的書我也很愛,polity也是一寶。

















成為程式設計高手的八大奧秘, 作者:白星海(大陸知名程式設計師)


















Wednesday, June 24, 2009

select all table name all field name in one database

select all table name all field name in one database

use your_db_name

FROM sys.objects o
JOIN sys.columns c ON o.object_id = c.object_id
JOIN sys.types t ON c.system_type_id = t.system_type_id
WHERE not like 'sysname'
and not like 'sys%'
and not like 'queue_messages%'

--group by

Tuesday, June 23, 2009

Windows 管理 (manage) > 服務 裡面的東西,,像是裝 apache, mysql 後會出現在那

Windows 管理 (manage) > 服務 裡面的東西,,像是裝 apache, mysql 後會出現在那
那個叫做 service controller,可以用 start > run > cmd > sc.exe 來呼叫

因為米沙剛裝 MySQL 是用 "解壓縮直接用" 而不是 "安裝版" 的版本

所以在 我的電腦 > 右鍵 > 管理 > 服務 這裡面沒有 "MySQL"


把 CMD 打開,然後輸入

sc create MySQL555 binPath= "\"D:\uo\MySQL Server 5.0\bin\mysqld-nt\" --defaults-file=\"D:\uo\MySQL Server 5.0\my.ini\"" DisplayName= "MySQL555aaaaa"


1. 等號 = 後面有空格 ( 但參數後面的 等號 = 不用空格)
2. 路徑要用 \" \" 框起來

sc.exe 還有其它的功能 和 選項 / 參數等,有興趣的自己看看

ps. 以下是別人說得,正港把它貼上
and you must NOT specify any other run mode
argument, such as --daemon, --tunnel, --inetd, or any of their short
forms. There is no short form for --service.

因此不能使用 -r 而應該用 --root

Running Apache as a Service

Apache can be run as a service on Windows NT. There is some highly experimental support for similar behavior on Windows 9x.

You can install Apache as a service automatically during the installation. If you chose to install for all users, the installation will create an Apache service for you. If you specify to install for yourself only, you can manually register Apache as a service after the installation. You have to be a member of the Administrators group for the service installation to succeed.

Apache comes with a utility called the Apache Service Monitor. With it you can see and manage the state of all installed Apache services on any machine on your network. To be able to manage an Apache service with the monitor, you have to first install the service (either automatically via the installation or manually).

You can install Apache as a Windows NT service as follows from the command prompt at the Apache bin subdirectory:

apache -k install

If you need to specify the name of the service you want to install, use the following command. You have to do this if you have several different service installations of Apache on your computer.

apache -k install -n "MyServiceName"

If you need to have specifically named configuration files for different services, you must use this:

apache -k install -n "MyServiceName" -f "c:\files\my.conf"

If you use the first command without any special parameters except -k install, the service will be called Apache2 and the configuration will be assumed to be conf\httpd.conf.

Removing an Apache service is easy. Just use:

apache -k uninstall

The specific Apache service to be uninstalled can be specified by using:

apache -k uninstall -n "MyServiceName"

Normal starting, restarting and shutting down of an Apache service is usually done via the Apache Service Monitor, by using commands like NET START Apache2 and NET STOP Apache2 or via normal Windows service management. Before starting Apache as a service by any means, you should test the service's configuration file by using:

apache -n "MyServiceName" -t

You can control an Apache service by its command line switches, too. To start an installed Apache service you'll use this:

apache -k start

To stop an Apache service via the command line switches, use this:

apache -k stop


apache -k shutdown

You can also restart a running service and force it to reread its configuration file by using:

apache -k restart

By default, all Apache services are registered to run as the system user (the LocalSystem account). The LocalSystem account has no privileges to your network via any Windows-secured mechanism, including the file system, named pipes, DCOM, or secure RPC. It has, however, wide privileges locally.
Never grant any network privileges to the LocalSystem account! If you need Apache to be able to access network resources, create a separate account for Apache as noted below.

Sunday, June 21, 2009

Thursday, June 18, 2009

network card extremely slow host-to-guest file transfers in VMWare 2.0 beta 2

network card extremely slow host-to-guest file transfers in VMWare 2.0 beta 2
on June 20, 2008
in cyber security
. 2 Comments Tags: CentOS 4.0, CentOS 4.6, extremely slow network, guest, host, Intel 82566mm, large send offload, LSO, RHEL 4.0, RHEL4.6, slow file transfers, T61p, TCP segmentation offload, TSO, virtual machine, VMWare 2.0.

In case anyone else encounters this problem, I am making a quick post on this. I am running Windows Server 2008 Standard on my T61p Thinkpad with WVWare Server 2.0 beta 2 and have a guest OS running CentOS (RHEL) 4.6. NIC on my T61p is an Intel 82566MM GigE. With an SSH file transfer from my Win2k8 host to my CentOS 4 guest, encountered extreme slowness…like 5kb/s. That is like modem speed. I updated the CentOS kernel perhaps thinking that the problem would lie there. No change. A little googling and I found that TSO (tcp segmentation offload) needs to be turned off on the host OS NIC settings. The Windows equivalent of TSO on the Intel Driver is called Large Send Offload, or LSO. So I disabled this on the IPV4 properties and bingo. Now getting 800kb/s.











你如果是有現成的版子,就找 raid 卡來試試.我覺得 LSI 這種大牌子不會有啥問題.話說他把 3Ware 買下來了

SATA - Advanced Host Controller Interface

SATA - Advanced Host Controller Interface

Tuesday, June 16, 2009

PHP file_get_contents function slow

PHP file_get_contents function slow

there are few possible issues:
- fileInfo 不選?
- CGI 不選?
- Socket 選?
- Hardened-PHP Project. Suhosin Protection disabled it?
- IPv6 不選 (FreeBSD, Apache, PHP, 都不要去 support IPv6 的款)

Monday, June 15, 2009

Exclude directory in tar and zip

OK - I figured it out. It turns out the GNU Tar which I have as I use
Ubuntu requires that the path to be tar'd come after the exclude
options. The example listed here had it before.


tar -cvf httpdocs_06_20_2006.tar.gz
--exclude "/home/user/"
--exclude "/home/user/"


tar -cvf httpdocs_06_20_2006.tar.gz
--exclude "/home/user/"
--exclude "/home/user/"


tar -zcvf httpdocs_06_20_2006.tar.gz -X a_list_of_exclude_path.txt /home/user/

Friday, June 12, 2009

Improving Drupal's page loading performance

Improving Drupal's page loading performance

Article published on January 30, 2008


Google dominates the search engine market for a large part thanks to its spartan, no-bells-nor-whistles interfaces. But also thanks to its incredible speed (which is partially thanks to that spartan interface, of course).

Since you're reading this article, you're probably a Drupal developer. It's pretty likely that you've had some visitors of your Drupal-powered web site complain about slow page load times. It doesn't matter whether your server(s) are shared, VPSes or even dedicated servers. Visitors that live abroad – i.e. far from where your servers are located – will face the same performance issues, but at even worse scales.

This article is about tackling these issues.

Front-end performance

Faster servers with more memory stop improving your web site's performance at some point. Yet, even before your web site gets big, there are other places to look at to improve performance, where greater effects can be achieved, even at lower costs – significantly lower costs actually. Typically, less than 20% of the total response time is used to retrieve the HTMl document. That means the other 80+% is used to process what's in the HTML file: CSS, JS, images, videos. And in many cases, that number is even higher.

Depending on your website, your server(s), et cetera, these optimizations will probably shave off between 25 and >100 percent (estimated) of your page loading time. Initial (empty cache) and consecutive page loads (primed cache) will both be significantly faster, unless you've already done your own round of optimizations.

Much thanks go to Yahoo!'s research that resulted in fourteen rules and the accompanying YSlow tool (we'll get to that in a second) that allows you to check how your web site performs according to those rules. If you can apply all fourteen successfully, your web site should fly. (Assuming that your page generation times aren't super slow, of course.) As always, more optimizations are still possible. I'll discuss some very effective ones briefly at the end.


First things first: make sure you've installed Firefox, Firebug and YSlow for Firebug (version 0.9 or better).

Firebug is simply a must-have for any web developer, it doesn't matter whether you're a professional or an amateur. YSlow is a Firefox add-on developed by Yahoo!, that analyzes your web page and tells you why exactly (remember those fourteen rules?) your site is slow (hence "y-slow", which is pronounced as "why slow"). But at the same time, it tells you how you can fix those pain-points. The lower the rule number, the greater the effect.

What follows is a comprehensive, yet pretty complete review of how Drupal 5 and 6 score on each rule, by listing the required features, settings or guidelines.

If you want to skip the information and want to see results, just skip to the part where I explain how you can apply the optimizations to your site.

Rule 1: Make fewer HTTP requests


Drupal 5

Drupal 6

CSS aggregation



JS aggregation



Generate CSS sprites automatically



Drupal even has the ability to compress CSS files (through stripping comments and whitespace). JS aggregation has been added in Drupal 6. To my knowledge, not a single CMS/CMF ships with the ability to generate CSS sprites. Nor does a single one have a module or extension that allows them to do so. This could be a Drupal key performance feature, if it were supported.


The easiest way to reduce this significantly is to enable Drupal's CSS and JS aggregation. You can find these settings at admin/settings/performance in your Drupal site.

If you're using Drupal 5, there's a backport of Drupal 6's JS aggregation feature, you can find it in this issue – I sponsored this patch.

There is not yet an automatic CSS sprite generator module for Drupal. If your site is styled pretty heavily, this would benefit you even more than CSS and JS aggregation. I hope somebody – or some Drupal company – will take the initiative.

In the mean time, there's a free CSS Sprite Generator out there, if you don't mind doing it manually.

Rule 2: Use a CDN


Drupal 5

Drupal 6

Alter URLs of served files dynamically



Drupal's File API needs work: it should be trivial to alter file URLs dynamically, e.g. based on the file size or type of a file.


I chose to tackle this particular problem myself, because using a CDN greatly enhances the usability of your web site for visitors that live far away from your servers. And one of the projects I'm working on, is one with a very international audience.

The first part of what's needed, is obviously to update Drupal core to support file URL altering. I chose to create a new function, file_url(), through which all URLs for files should be generated, including the URLs for additional CSS files in the page.tpl.php file (e.g. for a print.css file). This patch also provides a new hook: hook_file_server(), through which modules can provide new file servers. To configure the preferred file server, a new "File servers" setting has been added to the File system settings form. If one server can't serve a file, Drupal will try the second server, and so on. It will always fall back to the web server Drupal is being served from if all servers provided by modules failed.

Currently, I've only got a Drupal 5 patch (it's included in the CDN integration module and attached at the bottom of this article), because I want to get more feedback before I start maintaining patches for 2 different versions of Drupal. As soon as the patch ends up in its final form, I will provide a Drupal 6 patch, and of course push for Drupal 7 inclusion. An issue at has been created.

The second part – integration with a CDN – obviously requires an implementation of hook_file_server(). So the CDN integration module was born. It's written with flexibility in mind: it supports synchronization plugins (currently ships with one: FTP), can create unique filenames or directories (necessary if you don't want to break relative paths), provides the tools to check whether your filters are working well (per-page and site-wide statistics) and the filters can be configured using parameters similar to Drupal's file_scan_directory() function.

An article that includes benchmarks of the effects of the CDN integration module is being worked on. The same article will include a complete installation tutorial as well.

Rule 3: Add an Expires header


Drupal 5

Drupal 6

Don't set the Expires header for web pages



Set the Expires header for all other files



Allow far future Expires headers: ability to alter URLs of served files dynamically



By setting the Expires header for files, you tell the browser that it's ok to cache them.

Drupal sets the "Expires" header for all other files than web pages to 2 weeks. This is sufficient for most uses. For maximum performance, this should be set to a date in the far future (e.g. 10 years from access), but this requires unique filenames: each time the file is updated, the filename should change as well this is why file URL altering is a requirement. If not, your users could still be using the old files, since they may be in their cache.


Changing the future date for the Expires headers is easy enough: simply edit your .htaccess file. Your Apache server must also have mod_expires installed, this is available by default on most servers. However, making filenames unique is an entirely other matter. The altering of file URLs is already solved in the solution for rule 2. So all you have to do now, is implementing a file server that supports this. The aforementioned CDN integration module provides this feature, but if you want to use it, you of course have to use a CDN.

Rule 4: GZIP components


Drupal 5

Drupal 6

GZIP web pages



GZIP CSS and JS files



When Drupal's page caching is enabled, pages are written to the cache in GZIPped form! To learn more about how Drupal handles GZIPping, run this command from your Drupal root directory:

egrep ‑rn "gzip" .

Don't forget the dot at the end!

However, Drupal does not yet allow you to gzip CSS and JS files.


A Drupal core patch for this is being worked on, but has unfortunately been inactive for quite some time.

If you are using my CDN integration module, you don't need to worry about this, since CDNs GZIP files by default, if the client supports it.

Alternative solution

As an alternative, you could configure your Apache server to automatically compress files.

An example for Apache 2.x: add the following lines to your .htaccess or httpd.conf file:

AddOutputFilterByType DEFLATE text/css application/x-javascript

Rule 5: Put CSS at the top


Drupal 5

Drupal 6

Abstraction to add CSS files to the web page



Default location in the XHTML document is the  tag



Drupal has this abstraction: drupal_add_css().

Putting stylesheets to the document HEAD makes pages load faster: it allows the page to be rendered progressively.

Rule 6: Put JS at the bottom


Drupal 5

Drupal 6

Abstraction to add JS files to the document



Default location in the XHTML document is just before



Drupal has this abstraction as well: drupal_add_js().

JS should be at the bottom, because browsers wait until everything in the  tag has loaded. As you probably know, JS files tend to be pretty large these days, so loading them might take a while, thus postponing the rendering of the page. If you'd put the JS files at the bottom, then your page can be rendered while the JS files are still loading! It also achieves a greater download parallelization, thus cutting down your overall page loading time.

This is also being discussed at


Unfortunately, the default value for the $scope parameter of drupal_add_js() is bad: 'header'. If we simply make 'footer' the default, we're good. The number of contributed modules that sets this to 'header' explicitly, is very low, so it shouldn't be too much work to convert these. And I've yet to encounter the first module that has issues with being at the bottom instead of the top.

A more complex part of the solution are Drupal's default JS files: misc/jquery.js and misc/drupal.js. These can be put in the footer without any issues whatsoever. But what if a contributed module chooses to put its files in the header? Then they may not yet be loaded! For maximum compatibility, we should add the default JS files to the header if at least one module chooses to add its JS file to the header.

I've attached patches for both Drupal 5 and 6, but neither implement the more complex part I just explained. In my opinion, Drupal should enforce a strict policy: all JS files should be "footer-compatible". Until somebody can point me to some JS that must be in the header to work properly, I'm unlikely to change my opinion about this proposed policy.

Alternative solution

The second method to fix this, doesn't involve hacking Drupal core, but is also more hassle since you have to repeat it for every theme you're using. Suppose you're using the default Drupal core theme, Garland. Then open the themes/garland/page.tpl.php file in your favorite editor. Find this line at the top of the file:


Cut it away from there, and put it just before this line at the bottom:


So your end result should look like this:


As you can see, it now comes just before the closing  tag. (Well, also before the $closure output, which is the output generated by all hook_footer() implementations.)

Rule 7: Avoid CSS expressions


Drupal 5

Drupal 6

No default theme should implement it



CSS expressions are not recommended, because they're evaluated many times: when the page is rendered or resized, but also when the page is scrolled. Even when the user moves the mouse over the page!

None of the Drupal core themes uses CSS expressions. Just make sure you don't use it in your own themes.

Rule 8: Make JS and CSS external


Drupal 5

Drupal 6

Inline CSS and JS should be avoided or used sparingly



If your web site is a common homepage for many users, you may want to use a custom strategy and read this. Otherwise, you can ignore this rule without worrying.

Rule 9: Reduce DNS lookups


Drupal 5

Drupal 6

Use 2-4 hostnames by default: ability to alter URLs of served files dynamically



To my knowledge, not a single hosting provider offers a static file server by default. So it makes a lot of sense that Drupal doesn't do it by default. However, Drupal should support it out-of-the-box.

If you use a lot of so called widgets (those small blocks of content provided by Flickr,, MyBlogLog, and so on) on your site, you'll have some extra work to do.


The altering of file URLs is already solved in the solution for rule 2. So, once again, all you have to do now, is implementing a file server that supports this.

If you use my CDN integration module, then you'll be using 2 hostnames or more, but this of course requires you have access to a CDN.

Alternatively, you can use a static file server. Robert Douglass' article on using Drupal with a static file server is a very complete reference: from the pros and cons to the entire server setup.

See Yahoo's documentation for more details.

Widgets solution

If you're using a lot of widgets and you want to continue using them, you can. The solution is simple: cache as much as possible on your own site (or to your CDN).

For example, if you use Google Analytics, make sure you've installed the Google Analytics module, which has an option to cache the .js file locally (and update it once each day, to make sure you're serving the latest version).

Rule 10: Minify JavaScript


Drupal 5

Drupal 6

JavaScript minification



This was originally included in Drupal 6 core. However, it has been removed because it was problematic; it would result in boatloads of JS errors, and thus the JS would simply stop working. The technique used by Drupal 6 was Dean Edwards' packer, also nicknamed packer.


Packer, isn't just a minifier, it's also an obfuscator. A minifier only strips whitespace and comments, but an obfuscator also munges the code; it renames variable and functions as short as possible. For this, the packer uses a reduction algorithm (hence its name). However, this has serious consequences for the page loading time as well: it can easily take 200 ms to unpack the JS! Additionally, the effectiveness of GZIPping packed JS files is much lower.

More reliable alternatives are JSMIN (minifier/uglifier), Dojo Shrinksafe (minifier/obfuscator) and YUI Compressor (minifier). The last two are built on top of Rhino, Mozilla's Javascript engine, written in Java. Therefor neither qualify for Drupal core inclusion. A JSMIN PHP implementation exists, so I think this is the best choice.

There's an issue to add this to Drupal 7.

Rule 11: Avoid Redirects


Drupal 5

Drupal 6

Avoid redirects by default



Drupal could redirect users accessing the non-aliased URL /node/11 to the aliased version /about, but it does not – at least not by default.

The Global Redirect module implements this feature in a sensible way. See the project page for a complete explanation.

Rule 12: Remove Duplicate Scripts


Drupal 5

Drupal 6

Abstraction to add JS files to the document



Drupal has this abstraction, as mentioned in rule 6: drupal_add_js(). You then just use a static variable to prevent adding the same file multiple times. For an example, see the jCarousel module.

Rule 13: Configure ETags

This is the only rule that depends completely on the server setup. An ETag uniquely identifies a file, and is used to verify if the file in the browser's cache matches the file on the server.

The problem is that they are generated using attributes specific to the server (inodes) they're being served from. This implies that when, for example, you're using multiple servers behind a load balancer, you may one time be accessing the files from server 1, another time the files from server 2. And since the ETags don't match, you'll be downloading the file again!


If you're using multiple servers, disable ETags. For Apache users: add this line to your httpd.conf:

FileETag none

IIS users have to follow a more complex procedure.

Alternative solution

Use a single server to serve files, or a CDN. See the solutions for rules two and nine for detailed information.

Rule 14: Make Ajax Cacheable


Drupal 5

Drupal 6

Pluggable render formats



Ability to set GZIP-ability per format (i.e. rule 4)



These feature was being worked on for Drupal 6, but unfortunately wasn't ready in time.

The ability to set the GZIP-ability per output format (i.e. rule 4) should be handled at in the same patch, or in a follow-up, since it affects the performance of AJAX callbacks so much.

Other - but mostly less important - rules that are implemented automatically: rules 9 and 13 (AJAX responses will be served from the same server as Drupal), rule 11 (redirects are extremely unlikely to be used for AJAX callbacks in Drupal). Rule 10 is almost completely irrelevant, because GZIPping JSON data has a much greater effect.


The node rendering refactoring issue is listed for the Drupalcon Boston 2008 code sprint, so we'll probably see this in its final form in a couple of months.

Applying this to your site

This is of course a boatload of information. The easiest way to apply all of it to your site, is by installing my CDN integration module, and using the included Drupal core patch that also adds JS aggregation and puts JS files at the bottom (by changing the default scopes).

Live sites

Before you start applying this to your site, you of course want some proof that all these optimizations do indeed have an effect. No problem. You're looking at it. This page should have been loaded in less than a second. Subsequent page loads should complete in less than half a second. With Drupal's page caching disabled (!), eAccelerator installed and a MySQL query cache in place.

Another live site is DrupalBin. That site is running on a shared server (DreamHost), without eAccelerator and without a MySQL query cache – which explains the often slow page generation times.

Additional optimizations

In order of effectiveness:

The Boost module enables Drupal to perform static page caching. This means that rendered pages are written to files, and through some mod_rewrite magic, it will serve the statically cached page from the file if it's available, thus without even a single DB query!

This article at 2bits is chock full with Drupal performance tips.

The core patches module Advanced cache, again by Robert Douglass, provides caching for blocks, comments, the forum structure, built nodes, path lookups, popular search queries and taxonomy trees.

Drupal issues

#101227: GZIP aggregated CSS and JS, by Owen Barton (Grugnog2) and Ted Serbinski (m3avrck).Has some patches, but is out of sync.

#210447: Introduce Javascript compression, by Nedjo Rogers (nedjo). Doesn't have patches yet.

#134478: Refactor node rendering, by Jeff Eaton (eaton) et al.

#214934: file_url() and hook_file_server(), by Wim Leers.

More information

High Performance Web Sites (video of presentation), by Steve Souders.

Explains all YSlow rules in detail.

CSS Sprites: Image Slicing’s Kiss of Death, by Dave Shea, A List Apart.

Explains the need for CSS sprites, how they work and the pittfalls.

CSS Sprites: How and Improve Web Performance,

Case-study that may be interesting if you're learning about CSS sprites.

CSS Sprite Generator Tool, by Stuart Colville, Muffin Research Labs.

Announcement of the aforementioned CSS sprite generator.

Announcing SilkSprite: A CSS Sprite Plugin for Blueprint, by Don Albrecht, Ajax

Automatic CSS sprite generator for the Blueprint CSS framework.

Performance Research, Part 2: Browser Cache Usage - Exposed!, by Tenni Theurer's, Yahoo! User Interface Blog.

Aptly describes why it's important to not forget about page views with an empty cache.

Serving JavaScript Fast, Cal Henderson, Vitamin.

A pretty complete reference on how to serve GZIPped CSS and JS files.

Gzip Your Minified JavaScript Files, Julien Lecomte.

A comparison of how well GZIP-able minified JS files are, after using a certain minifier. Also explains why the packer should not be used due to its reduction algorithm.

Static Page Caching for Drupal 4.7, Arto Bendiken.

Announcement of the Boost module.

Page Load Time Worksheet, Tag 1 Consulting, Inc.

This worksheet can help you to isolate and fix bottlenecks affecting your page load times.

Thanks to …

Yahoo! for their work on YSlow.

Greg Knaddison (greggles) for proofreading this article and making several excellent suggestions to make this article more complete.



JS at the bottom - Drupal 5.patch

1.08 KB

JS at the bottom - Drupal 6.patch

1.28 KB

hook_file_server - Drupal 5.patch

11.61 KB




page loading performance


61226 reads


January 30, 2008 - 05:55 — deekayen (not verified)

good job

This is certainly worth a space in my bookmarks.


January 30, 2008 - 07:19 — Jorge (not verified)

Great article! Thank you

Great article! Thank you


January 30, 2008 - 08:27 — Dries (not verified)

Great article

Great article, and careful analysis. I've written about YSlow before ( -- and I have been recommending it to a lot of people. It should be part of the "Drupal development toolchain" that every developer uses.

The Javascript position issue is interesting -- we should enforce good behavior through our APIs and make the required changes. Why would we allow Javascript to be placed at the top of the page?


January 30, 2008 - 15:22 — Ximo (not verified)

In some cases this is needed

AFAIK, loading JS at the bottom should be fine in most cases - jQuery usually works unobtrusively by interacting with the DOM once the document is ready. As long as the jquery.js file is loaded before any jQuery code, there should be no problem.

There are however some situations where you'd want jQuery to do its magic before the document is completely loaded, such as dynamically adding classes to elements to change their appearance. If this has to wait for the bottom of the document to be reached, one would experience an annoying glitch as the code is run. An exampe of this is the plugin to add rounded corners to boxes.

So loading jquery.js and drupal.js in the footer by default, and in the header if a module has added some JS there, sounds reasonable. Themes may add JS directly into tpl.php files, but this is bad practice anyway, one should use drupal_add_js() instead.



January 31, 2008 - 09:39 — andremolnar (not verified)

Not quite correct - this has been tested

Please see:

I was under the same impression - but decided to run tests. If you want to manipulate the DOM there is virtually no difference whether you place $(document).ready(function(){//DOM manipulation}) at the top or the bottom of the page. See the link for complete details.

If anyone finds a flaw in the testing method or has some additional insight please share in the thread on g.d.o



January 31, 2008 - 18:39 — ximo (not verified)


Yea, I corrected myself in that same thread. I was speaking from my own experience and what I've learned from others, but the problems I had may have been caused by something else.

Anyway, loading the required JS files from  if needed would allow the few scripts who depends on this to run as well. One would only have to specify "header" as the scope instead of the (as suggested) default "footer".



June 30, 2009 - 08:39 — rtbox (not verified)

you may want to call a

you may want to call a function such as swfobject inline, having the code at the bottom breaks this. I am aware that you can just call the function below the script declaration however this is not really possible if you will be posting into the content of a node.


January 31, 2008 - 21:16 — Wim Leers

Excellent question

That's an excellent question, but I'm afraid I can't answer this yet either.

I've searched a lot, but failed to find any information regarding this rather critical topic. Not even a mention on A List Apart.

I've contacted John Resig about this, asking him to comment here.


February 8, 2008 - 22:33 — Konstantin (not verified)

Why would we allow

Why would we allow Javascript to be placed at the top of the page?



January 30, 2008 - 09:00 — Grugnog (not verified)


What can I say - this is the most complete article I have seen on this topic by far.

Oh if only this (and YSlow!) had existed when I was trying to convince everyone that we needed to aggregate CSS!

Next stop - gzipping for D7 :)


January 30, 2008 - 09:21 — Sina Salek (not verified)

Very very useful

Thanks, very very useful specially the CDN module. good work man


January 30, 2008 - 09:34 — avior (not verified)

Thank you

Thank you for that great work

very informative , and helpfull


January 30, 2008 - 14:32 — Benjamin Melançon (not verified)

Good stuff-- one more resource

Very helpful stuff, Wim!

Here's one more major resource I didn't see listed:

Drupal Performance Agency's checklists and worksheets, see "Documents" on that page:

The docs cover some server and MySQL tuning as well as PHP and Agaric in a very systematic way. It was helpful at the right time for Agaric to keep World Social Forum 2008 online.

benjamin, Agaric Design Collective


January 31, 2008 - 21:20 — Wim Leers


I've never heard of that Drupal company, but they seem to have a great team and do great things.

Thanks for the link, I've added it to my more information section.


January 30, 2008 - 14:34 — ximo (not verified)

Great article!

I don't think much more can be said on the topic, and the links are excellent. Great resource for all of us, both n00bs and those who know abit about "frontend" performance :)




January 30, 2008 - 14:37 — Gábor Hojtsy (not verified)

rule 3 addendum for Drupal 6

Well, your observation in rule 3 for Drupal 6 is not entirely up to date. The CSS and JS file serving was changed in the RC phase to include a query string which changes on every update.php run and when all caches are flushed. So basically Drupal has a built-in way to 'rename' the URLs for the static CSS and JS files with short query string additions. (BTW this grown out of a bug fix for Garland to show up the new styles and behaviors with Drupal 5 -> 6 upgrades, even though the file names are the same).


January 31, 2008 - 21:41 — Wim Leers

Not quite what's necessary

Although it covers the basics of what is necessary, it's very ineffective, in that it forces a refresh of all files!

Please correct me if I'm wrong :)

(Relevant d.o issue: #199946.)


February 1, 2008 - 00:43 — Gábor Hojtsy (not verified)

you are right

Yes, you are right. Since Drupal cannot afford to check for the dates of all files each time they are served, we don't know about that, so all we can do is to refresh files on upgrades / updates. There is lot of stuff to do here in Drupal 7 and in contribs for Drupal 6.


February 1, 2008 - 01:53 — Wim Leers

Current approach & thoughts

My current approach is to keep an array with source file paths (i.e. the ones that are actually Drupal's web server) as keys and destination file paths (i.e. the ones synced to the CDN) as keys in the variable table. The destination file paths already contain the unique filenames (or unique directory, to not break relative paths for e.g. CSS files).

So, currently, it doesn't scale: if you're working with thousands of files, the size of this array will grow into the megabytes, which is unacceptable. This will have to be reworked to work with DB queries.

But then the same problem as for URL aliases arises: lots of queries per page, but files are typically only in the 5-20 range (with CSS/JS aggregation enabled of course), whereas URL aliases are very often in the >100 range.

We can reduce the number of queries by still putting the most commonly used files in an array.

If there's some info on best practices in this area available, let me know ;)


January 30, 2008 - 18:05 — heyrocker (not verified)

Content Synchronization

This is a fantastic article and I can see a ton of potential uses for the CDN module even above and beyond using it for CDNs. One of the parts of the module that I find most interesting is the content synchronization piece. I work in a situation where we have a dev/qa/production deployment process, and multiple load balanced production servers, so content synchronization is always rearing its head in various forms. Would you consider pulling this functionality out into its own module which is basically a black box for pushing files around? I think there are a lot of uses the community could find for such a module.


January 31, 2008 - 21:47 — Wim Leers

Partially done already by design

This is partially done already: the module supports synchronization plugins. Currently there's only one plugin: FTP.

The part that scans for files that need to be synchronized (based on the filters configured by the user, so highly customizable) are all contained in the pretty small file (320 lines and it contains loads of cron-specific stuff that could be ripped out).

I'll gladly accept patches, but I won't start a separate module for this just yet – plenty of work already with the modules I'm currently (co-)maintaining. If you'd like to sponsor it though, you can contact me.


January 31, 2008 - 00:22 — links for 2008-01-30 &laquo; Mike&#8217;s Blog (not verified)


[...] Improving Drupal’s page loading performance (tags: drupal web2.0) [...]


January 31, 2008 - 01:21 — /dev/random :: links for 2008-01-30 (not verified)


[...] Improving Drupal’s page loading performance (tags: drupal web2.0) [...]


February 1, 2008 - 04:27 — ultimike (not verified)


Thanks for the great article - this is the by far the most comprehensive guide for tackling all the issues that yslow has been pointing out on all our Drupal-powered sites.

You've done a real service to the Drupal community here.



February 3, 2008 - 13:55 — Wim Leers

Packer decompression delay

I updated the article with an explanation about the decompression delay due to the way Packer works.


February 4, 2008 - 11:18 — dalin (not verified)

Can't always move $scripts to end

I've got a situation where I can't move $scripts to the end of the document. I've have a site frontpage that uses several jcarousels to scroll through images. There's also a few ad blocks on the page. The adblocks contain a script tag that calls the ad js. That js uses document.write to print code for either an image or flash. Unfortunately this isn't exactly an instantaneous process and in the time it takes for this snippet of html to be generated and sent, the page has already begun to be rendered. If I were to use document.ready for the jcarousels, they wouldn't be formated until the page is completed loading and would cause a flash of styled content (it's fairly significant if you have a lot of styling of this nature). So the solution is to put the jcarousel code imediately after the ul that it styles, and don't use document.ready, just use the jquery function directly. So for this to work the jquery library needs to be loaded before this point, i.e. in the head.

I can see this becoming an increasingly common situation as we see ever more amounts of javascript in everyday webpages.


February 4, 2008 - 19:41 — Wim Leers


I agree. Ideally, the changes performed by JS should not affect the display: when JS is enabled, the same "initial view" should be present, through CSS only. This is of course not realistic.

However, your method to prevent flashing (putting the .js files in the HTML head and calling the jcarousel() method immediately after the ul it styles) seems awkward: we don't want inline JS. Isn't putting the JS code in the head of the document itself enough to guarantee a flawless load?

For readers interested in reproducing this issue: see my Mini panels demo, which has a jCarousel.


February 5, 2008 - 02:32 — dalin (not verified)

didn't work for me

Moving the jcarousel code to the header doesn't work for me. This makes sense in my mind since the ul in question doesn't yet exist at this point.


February 5, 2008 - 20:34 — Wim Leers

Please try this …

Please try this:

$('ul#some-id').ready(function() {

  // jCarousel initalization


(i.e. use a selector instead of document)


February 26, 2008 - 13:51 — Christian Schmidt (not verified)

ETag on load-balanced Apaches

An alternative to disabling FileETag when running multiple load-balanced Apaches is to let Apache consider only the file size and last modification time when generating the ETag. This is done using the following config line:

FileETag MTime Size

This setting requires that files are copied to the parallel servers in a way that preserves the last modification time (and that files aren't modified several times per second without changing size, but this probably isn't a problem).


February 26, 2008 - 17:21 — Wim Leers


Thanks for your addition!

I knew there were ways to preserve ETags, but I deliberately chose to not enter that topic, because that would lead me too far off the focus.


February 26, 2008 - 13:54 — Dan Frost (not verified)

Excellent post

What an excellent post. I was just starting to post something similar but decided against it when reading yours as it covered the topic perfectly. Very useful and well laid out - thank you.

I think it's worth mentioning that Live Search (MSN, whatever) have confirmed that they do use ETags and there are ways of sync'ing ETags in both Apache and IIS when used in a cluster.

There's no evidence (that I can find) that Google use ETags - they play it safe by using If-Modified-Since.

Oh, YSlow can (ironically) slow down your browser (at least it did on mine) so I'd disable it when not using it specifically.



February 26, 2008 - 17:21 — Wim Leers


Indeed there are ways to do that. Actually the comment that was posted just before your own describes such a method :)

And indeed, YSlow – like just about any other Firefox add-on – slows Firefox down. I choose to have YSlow and the Web Developer Toolbar enabled at all times, since I use it for web development only. I uninstall all other add-ons.


October 11, 2009 - 00:13 — at yarışı (not verified)

great article

What an excellent post. I was just starting to post something similar but decided against it when reading yours as it covered the topic perfectly. Very useful and well laid out - thank you.


February 28, 2008 - 20:22 — magnum blog &raquo; Blog Archive &raquo; links for 2 (not verified)


[...] Improving Drupal’s page loading performance | Wim Leers (tags: drupal performance optimization articles css howto yslow) [...]


March 4, 2008 - 12:15 — Alan F. (not verified)

Thanks for this excellent

Thanks for this excellent post and analysis.

Specially for "Solutions".


March 21, 2008 - 19:26 — Wim Leers

Yahoo! posted 20 additional optimization rules

Yahoo! posted 20 additional optimization rules on. They'll provide an in-depth explanation later, but it's interesting already. See


May 22, 2008 - 05:22 — IceCreamYou (not verified)

I've been wondering how to

I've been wondering how to improve my YSlow score for awhile, since most of the things YSlow tells me aren't modify-able for anyone who isn't really capable of tampering with PHP and .htaccess files. This article should help. Thanks!


May 26, 2008 - 03:41 — Timmy Carter (not verified)

thank you ! great article

thank you ! great article !

really helpfull


July 23, 2008 - 20:46 — Sienna (not verified)


It really works great as well. Drupal is getting better and better. thanks


May 26, 2008 - 12:33 — Pedro Pablo (not verified)

improvement for css and js aggregation

Great and useful article. The definitive guide!! :-)

for your info, recently a simple and smart module to compress css and js files has been published at The name is Smartcache and author's nick is Gremlinc5.

I have tested it and works fine, and you don´t have to tweak any core files, just add a .htaccess rule and a couple of files. Worths a look as maybe it has a place in your article.


May 29, 2008 - 18:37 — DIGG FRANCE (not verified)

Is Digg-France slow to load ?


Please can you confirm that my website is very slow to load ?

It's a Drigg module based websites and it seems quite slow.


ps: maybe you should add the comment_subscribe module for you site ;-)


June 13, 2008 - 09:04 — PenCake &raquo; Blog Archive &raquo; Drupal Related (not verified)


[...] Improving Drupal’s page loading performance | Wim Leers [...]


June 23, 2008 - 18:19 — lsabug (not verified)

I want to cache images but default sets header to 1978

I've gone through your recommendations (can't afford CDN) and my nagging problem is that drupal never seems to cache any of my images saved above root (private files structure). I have it set to cache images in my .htaccess file and I have mod_deflate, mod_expires and mod_headers enabled in apache.

YSlow shows says images on my front page do not have a far future Expires header:


I know the default for headers in bootstrap is 1978 for content but how do I change for my private image files?

Here's my htaccess:

# Requires mod_expires to be enabled.

  # Enable expirations.

  ExpiresActive On

  ExpiresDefault "access plus 2 years"

  # Do not cache dynamically generated pages.

  ExpiresByType text/html A1

  # Set up 10 year caching on commonly updated files


  ExpiresDefault "access plus 10 years"



  # Set up 10 year caching on commonly updated files


  ExpiresDefault "access plus 10 years"


  # Force no caching for dynamic files


  ExpiresActive Off


More information:

Any and all suggestions will be appreciated : )


July 17, 2008 - 06:18 — rosedragon (not verified)

thank you

Thank you for your tutorial. I had use YSlow and tweak into JS at bottom and CSS at top. While drupal run module CSS at top, theme CSS at bottom, I change it viceversa, since I dont use any important CSS with module.

About the run module/theme CSS, I edit the value on if (!$preprocess && $type == 'theme') , like these:

          // If a CSS file is not to be preprocessed and it's a module CSS file, it needs to *always* appear at the *top*,

          // regardless of whether preprocessing is on or off.

          if (!$preprocess && $type == 'theme') {

            $no_module_preprocess .= ''."\n";


          // If a CSS file is not to be preprocessed and it's a theme CSS file, it needs to *always* appear at the *bottom*,

          // regardless of whether preprocessing is on or off.

          else if (!$preprocess && $type == 'module') {

            $no_theme_preprocess .= ''."\n";


Now, what I should do is to minimize the usage of images of my CSS.. since it use like useless 11 css images.


August 9, 2008 - 13:34 — Improve Drupal performance &laquo; chirale (not verified)


[...] Improving Drupal’s page loading performance [...]


August 10, 2008 - 20:29 — chirale (not verified)

CSS Sprites modules

I never try it, but there's a CSS sprites generator module for Drupal 5.x:


August 15, 2008 - 07:35 — xtfer (not verified)

Both FCKEditor and Google

Both FCKEditor and Google Analytics may choke if the JS is placed at the bottom, in their current state. What about placing the $scripts tag just inside the body tag?? What potential issues might this cause? Would it be an improvement?


September 15, 2008 - 19:57 — zuborg (not verified)

On-line site performance testing tool

I would also recommend this online free tool:

It measure loading speed of page and it’s requisites (images/js/css) like browsers do and shows nice detailed chart - so you can easily spot bottlenecks.

Also very useful thing is that this tool is able to verify network quality of your server (packet loss level and ping delays).


September 23, 2008 - 14:49 — GoldNumber (not verified)

Improvements in 3 times

Thanks for your arcticle. It helped me improve my site performance in more then 3 times.

The only problem for me now is improving internal Drupal performance such as page loading for authenticated users.


September 24, 2008 - 23:03 — Drupal Developer's Toolbox | Developer's Tool (not verified)


[...] Improving Drupal’s Page Loading PerformanceLooking to speed up a Drupal website? Try following these steps. [...]


September 25, 2008 - 01:26 — drupal malaysi (not verified)

will pay attention

great article, and we are going to start paying attention on this, especially the usage of YSlow. BTW, is not using CDN? It was listed as an example in CDN module?


September 25, 2008 - 15:11 — Wim Leers

You have to add

You have to add as the CDN used on the web site, then it'll increase the score. The CDN module is not yet ready for production use though. I'm also having a server issue because of which new files haven't synced yet at the moment of speaking, causing a couple of files not to be served from the CDN.


September 25, 2008 - 06:58 — Drupal Developer’s Toolbox (not verified)


[...] Improving Drupal’s Page Loading PerformanceLooking to speed up a Drupal website? Try following these steps. [...]


September 25, 2008 - 10:10 — Drupal Developer’s Toolbox | POLPDESIGN (not verified)


[...] Improving Drupal’s Page Loading Performance Looking to speed up a Drupal website? Try following these steps. [...]


September 26, 2008 - 01:04 — Vieno (not verified)


[...] Improving Drupal’s Page Loading PerformanceLooking to speed up a Drupal website? Try following these steps. [...]


September 26, 2008 - 02:15 — Drupal Developer’s Toolbox | rafdesign (not verified)


[...] Improving Drupal’s Page Loading PerformanceLooking to speed up a Drupal website? Try following these steps. [...]


September 26, 2008 - 16:08 — Drupal Developer’s Toolbox (not verified)


[...] Improving Drupal’s Page Loading PerformanceLooking to speed up a Drupal website? Try following these steps. [...]


September 26, 2008 - 16:08 — Drupal Developer’s Toolbox (not verified)


[...] Improving Drupal’s Page Loading PerformanceLooking to speed up a Drupal website? Try following these steps. [...]


September 26, 2008 - 20:33 — Drupal Developer’s Toolbox | ONGUIDESNET (not verified)


[...] Improving Drupal’s Page Loading Performance Looking to speed up a Drupal website? Try following these steps. [...]


October 7, 2008 - 09:24 — xzhang (not verified)

Very good article! Thanks

Very good article! Thanks


October 9, 2008 - 17:34 — For Drupal Developers - TechAdmin's Soul Asylum (not verified)


[...] Improving Drupal’s Page Loading Performance Bạn đang tìm cách tăng tốc cho các trang web của mình? Đây là cách giải quyết dành cho bạn. [...]


October 15, 2008 - 08:53 — Drupal Developer's Toolbox | Mind Tree (not verified)


[...] Improving Drupal’s Page Loading Performance Looking to speed up a Drupal website? Try following these steps. [...]


October 17, 2008 - 19:42 — Drupal Developer’s Toolbox (not verified)


[...] Improving Drupal’s Page Loading Performance Looking to speed up a Drupal website? Try following these steps. [...]


October 17, 2008 - 22:13 — Anonymous (not verified)

Smart Optimizer

I've found that a PHP library called Smart Optimizer works well with Drupal.

It automatically minifies, concatenates, and gzips CSS and JS and caches the resulting files to serve future requests. Super easy to setup as well - just copy the directory to your server and paste a snippet in you htaccess file. Makes a huge difference in Yslow.


October 22, 2008 - 19:57 — Anonymous (not verified)

Re putting .js files in footer

Great resource BTW!

I used your alternative suggestion and amended my theme to put the .js files at the bottom of the page. However it appears that this breaks FCKEditor, the editor simply does not show up! When I reverted to putting .js files in the header it worked again!

I'm using Drupal 6


October 25, 2008 - 22:37 — HGH (not verified)

Excellent Article

Man that was awesome. Going to bookmark it. Will refer to it often. Thanks!


December 17, 2008 - 06:21 — Mikhailov Anatoly (not verified)


Mod_deflate in apache2 is pretty much the same as mod_gzip in apache1.3, and mod_deflate is included with the apache2 source package. Both modules allow compressing of the apache server on the fly


December 26, 2008 - 04:05 — under construction | spiffy [d] :: blog (not verified)


[...] # [...]


December 29, 2008 - 19:29 — Speed Reading Course Review (not verified)

Very good tutorial

An excellent tutorial!

I learned a lot from this. Thanks so much.


January 8, 2009 - 22:11 — Zane Rokklyn (not verified)

Proof in the pudding?

Great advice! And I like how you challenge us to try loading the page to see how your tips work on your own site. Unfortunately, when I run Yslow on this page, it get this:

Performance Grade: C (71) Expand All Collapse All

D 1. Make fewer HTTP requests

F 2. Use a CDN

B 3. Add an Expires header

D 4. Gzip components

B 5. Put CSS at the top

A 6. Put JS at the bottom

A 7. Avoid CSS expressions

n/a 8. Make JS and CSS external

A 9. Reduce DNS lookups

C 10. Minify JS

A 11. Avoid redirects

A 12. Remove duplicate scripts

F 13. Configure ETags

Time to revisit your own advice? :-(


January 8, 2009 - 22:56 — Wim Leers

Temporary lack of pudding

I stopped using my CDN provider because it turned out they had very few PoPs and for that, I was no longer willing to pay. So it's simply because I'm no longer using a CDN. This is temporary.

I'm in my exam period currently, so I don't have the time to test with another CDN.

I'll fix it ASAP :)


January 15, 2009 - 15:01 — site development log | spiffy[d] (not verified)


[...] # [...]


January 20, 2009 - 05:09 — For Drupal Developers &laquo; Web for Dummies&#8217; (not verified)


[...] Improving Drupal’s Page Loading Performance Bạn đang tìm cách tăng tốc cho các trang web của mình? Đây là cách giải quyết dành cho bạn. [...]


February 9, 2009 - 00:57 — Rob Loach

JavaScript Aggregation

A small note that the JavaScript Aggregator module for Drupal 5 will aggregate the JavaScript for you. In Drupal 6, the JavaScript Aggregator module will use JSMin to compress/minify the aggregated JavaScript.


February 9, 2009 - 16:33 — Wim Leers

Yep, that's new since I

Yep, that's new since I wrote this article :)

I will probably post an updated version of this article in a couple of weeks.


February 26, 2009 - 11:42 — Florian Sievers (not verified)

JS in the Footer (unable to apply database updates)

I Just wanted to update my drupal from D6.9 to D6.10. Befor I startet the required database update, I reapplied the patch for JS in the footer (manually, because have been changed).

If "function drupal_add_js" had been changed to insert the JS in the footer, the database update can't be applied, because the script, that shows the progressbar, won't run.

Solution: First update the database and than patch Whenever you need to update the database (e.g. after module update), you must change to include JS in the header, and after that, you can reapply the patch.


March 2, 2009 - 23:48 — Ethos Blog &raquo; Drupal - A Quick Start up to Drupal (not verified)


[...] Improving Drupal’s Page Loading Performance Looking to speed up a Drupal website? Try following these steps. [...]


March 24, 2009 - 22:35 — mikeytown2 (not verified)

Rule 4: GZIP components

Been working with Rob Loach and his Javascript Aggregator now gzip's javascript. Based off of our work, I released CSS Gzip. No hacking of core required!


March 25, 2009 - 00:27 — Wim Leers

Great job!

I already noticed. Great work :) I'm sure it'll be appreciated by many Drupal users!


March 25, 2009 - 11:11 — Оптимизируем Drupal | CMS - Content Managment Systems (not verified)


[...] ниже расположен перевод заметки “Improving Drupal’s page loading performance”, в которой рассматриваются прикладные методы [...]


March 28, 2009 - 13:39 — Tổng quan về Drupal - CỘNG ĐỒNG PKC | PLEIKU - GIA LAI (not verified)


[...] hệ thống là một khía cạnh rất quan trọng. Hãy tìm hiểu từ bài viết này. Improving Drupal’s Page Loading Performance Bạn đang tìm cách tăng tốc cho các trang web của mình? Đây là cách giải quyết [...]


April 1, 2009 - 03:01 — Article translated into Russian and selected by Drupal Fire (not verified)


[...] article "Improving Drupal's page loading performance" – definitely my most popular writing thus far, bookmarked almost 350 times on delicious – has [...]


April 1, 2009 - 10:34 — Anonymous (not verified)

Help to improve loading performance ?


We are still trying to improve our Drigg based website .

Does anybody here could help? Please tell us what could be done to our digg-like and how much work it would need and cost ?

Thanks a lot.


April 8, 2009 - 18:34 — Robert Finale (not verified)

I need some improvements

It's so slow for me, so hopefully this helps.


May 7, 2009 - 16:07 — matt (not verified)

Sprite generator offset options?

for the css sprite generator, what do the offset options do, besides make the image bigger? Is there any reason the offset shouldn't be as little as possible? (The sprite generator doesn't accept an offset of zero, though I don't understand what the problem would be.)


May 13, 2009 - 00:50 — Roger (not verified)

Rule 6: Javascript at bottom breaks site

I installed the Javascript Aggregator module and it works great. Page load times are significantly improved. But when I tried to implement Rule 6, I had a problem.

The site makes heavy use of the Gmap module, with most of the pages featuring a Google map. When I tried to move the print $scripts ?> line to the bottom of the page, all of the maps disappeared, exposing the 'Javascript is required ... ' message. Returning the scripts to the  corrected the problem. (Drupal version 5.17)


June 21, 2009 - 19:05 — Anonymous (not verified)

I just wanted to say that

I just wanted to say that this script has really helped improve the general performance (and YSlow score!) of my company's Joomla site. I also wanted to say thanks. My Drupal 6.2 site's YSlow score improved from 69 to 81.

Keep up the good work. Cheers.


June 23, 2009 - 06:01 — OUVYT » Blog Archive » Daily (not verified)


[...] Improving Drupal's page loading performance | Wim Leers [...]


June 29, 2009 - 00:48 — More About Drupal | depiak (not verified)


[...] Improving Drupal’s Page Loading Performance Looking to speed up a Drupal website? Try following these steps. [...]


July 3, 2009 - 23:06 — Anonymous (not verified)

Huge article, thanks !

Huge article, thanks !


July 29, 2009 - 12:14 — Drupal 性能加速教程 | CMS网 (not verified)


[...] Improving Drupal’s Page Loading Performance Tagged with: 文章索引模板 [...]


August 19, 2009 - 00:20 — Improving Drupal&#8217;s page loading performance | Wim (not verified)


[...] View original post here: Improving Drupal’s page loading performance | Wim Leers [...]


August 26, 2009 - 18:19 — Anonymous (not verified)

Info on the webpage

Thank You for the article. I am still reviewing it.

I have a minor issue request. Could you tell me how you were able to add the "TAGS" option at the end of the article block where there are " apache Drupal Page loading performance performance " tag links.


August 27, 2009 - 00:39 — Wim Leers

Simple: through theming, in

Simple: through theming, in node.tpl.php :)


September 21, 2009 - 17:26 — Dan (not verified)

Great article

Really useful and definitely worth bookmarking. Now to get my head round how to implement some patches!


September 28, 2009 - 08:28 — danreb (not verified)


I applied some of the information written here to optimize my drupal site . The only thing I can't apply is the CDN module integration, but it improves much website performance so I'm happy with it.


October 3, 2009 - 05:54 — Drupal Developer’s Toolbox | 9Tricks.Com - Tips - Tricks - (not verified)


[...] Improving Drupal’s Page Loading Performance Looking to speed up a Drupal website? Try following these steps. [...]