<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Jul 11, 2006, at 3:01 PM, Gerhard Killesreiter wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Luckily, the problems we've had (namely the CPU on the db server being saturated) were resolved by more mundane means (optimze your database on occassion...), but since we continue to experience a growing number of visitors on drupal.org, better caching is no waste of time.</FONT></P> </BLOCKQUOTE></DIV><BR><DIV><A href="http://api.drupal.org/api/HEAD/function/drupal_page_header">http://api.drupal.org/api/HEAD/function/drupal_page_header</A> does not issue an authenticated header. If it did, we could use Apache 2.2 cache in memory or file caching. I suspect that serving cached pages from an apache cache in memory will avoid both a Apache HTTPD thread with PHP running at 20-30MB as well as avoid MySQL thread which can be massive if large buffers are configured for(frequently unnecessarily for both MyISAM and InnoDB by default) MySQL. This seems the cheapest an most effective place to cache short of getting another server for a Squid proxy.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><A href="http://httpd.apache.org/docs/2.2/caching.html">http://httpd.apache.org/docs/2.2/caching.html</A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>In the "What can be cached section?"</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "># If the request contains an "Authorization:" header, the response will not be cached.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "># If the response contains an "Authorization:" header, it must also contain an "s-maxage", "must-revalidate" or "public" option in the "Cache-Control:" header.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">This should be relatively straight forward. Anyone sitting on a patch for this already? Anyone care to share experience using Apache 2.2 caching?</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Cheers,</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Kieran</DIV></BODY></HTML>