<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>Not sure that I get a vote, but I reluctantly have to agree
with Howard. Is there a way that we can allow the bots to at least spider
the main page, but ignore anything else?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>Honestly, I really doubt that we'll get to 500 pages /
second with Drupal without throwing a more agressive caching strategy (Squid?)
or a better-performing CMS (is there such a thing?) in place. Or
going to static html :)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>But what are the options? As Howard has pointed out,
we have limited volunteer server admin resource, so what can we do with what
we've got? </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>Lets turn off as many modules as we can because each one
requires additional SQL queries. <SPAN class=311002415-29032007><FONT
face=Arial color=#0000ff size=2>Drupal can be a SQL pig; I've seen reports of
100+ queries to generate a single page, which is
unimaginable.</FONT></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>Is there anyone in the group with MySQL tuning
experience? If we can get MySQL set up as effectively as possible in DW
mode, this will help Drupal as well.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>We should consider turning off content-compression in
Apache. This isn't nearly as expensive as MySQL,
but...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007></SPAN><SPAN
class=311002415-29032007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>Another thing that should be looked into is why the server
is responding in a way that invalidates caches. This makes the bots see
our content as highly dynamic, and the'll come back for it way more
frequently.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=311002415-29032007><FONT face=Arial
color=#0000ff size=2>Jason</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> sac-bounces@lists.osgeo.org
[mailto:sac-bounces@lists.osgeo.org] <B>On Behalf Of </B>Swapnil
Hajare<BR><B>Sent:</B> Thursday, March 29, 2007 08:17<BR><B>To:</B> System
Administration Committee Discussion/OSGeo<BR><B>Subject:</B> Re: [SAC] Motion:
robots.txt, Drupal and performance<BR></FONT><BR></DIV>
<DIV></DIV>Hi<BR> as far as optimizing drupal performance is
concerned, it looks like some unnecessary modules installed can reduce the
performance. See <A
href="http://drupal.org/node/32091">http://drupal.org/node/32091</A> for some
possible ways of encountering performance hit. <BR> As far as I remember,
we have Access Stats module enabled, which is not useful really after having
installed awstats for access logs. Maybe we should disable it and also find out
more such modules which are not used at all. <BR><BR>regards,<BR>-- <BR>Swapnil
Hajare </BODY></HTML>