<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Yes to both. First I would make sure that the watchdog table is
InnoDB as that will help, especially on table locks. Another option
is to hijack the dblog module and create your own from it. Basically
just copy, rename what needs renamed (hooks, etc) and in
hook_watchdog filter out the things you really don't need written to
the database. Even better is replacing the storage for the watchdog
with something like MongoDB, sqlite or even plain old log files. <br>
<br>
An option on the email is to setup something like Google Apps or any
external email service for handling the emails, then use the SMTP
module to send all the emails through Google Apps. This saves some
decent load on the server since sendmail isn't fired for each email.<br>
<br>
(FYI - from a consultant stand point I always recommend Google Apps
to sites unless they have a ton of email addresses. It greatly
reduces the headache of handling email and gives the users an
interface that most of them are probably use to. I even use it for
my own company. Every client I have switched to it has been
thrilled.)<br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://www.intoxination.net">http://www.intoxination.net</a>
<a class="moz-txt-link-freetext" href="http://www.hollyit.net">http://www.hollyit.net</a></pre>
<br>
On 11/5/2011 10:44 AM, Ms. Nancy Wichmann wrote:
<blockquote
cite="mid:1320504242.59214.YahooMailNeo@web180311.mail.gq1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff; font-family:arial,
helvetica, sans-serif;font-size:12pt">
<div><span>I've been asked questions about a site that slows way
down on occasion. This is a cloud-based server at Rackspace.
Since Rackspace has a fairly good reputation, I am guessing
they are not the real problem.</span></div>
<div><br>
<span></span></div>
<div><span>I looked at the database stats; it is using Qcache
and the numbers look pretty decent.</span></div>
<div><br>
<span></span></div>
<div><span>What I do see that I question is that their
notifications module (I forget which one):</span></div>
<div><span>A) Writes to dblog (Watchdog) on every cron interval,
even if it has nothing to do (I hate that).</span></div>
<div><span>B) When there is a notification (pretty often), it
writes a separate line for each one.</span></div>
<div><span>C) Some of those notifications result in many (100 or
more) emails. During one page refresh when I experienced the
drastic slow down, this high volume email happened.</span></div>
<div><br>
<span></span></div>
<div><span>So I am wondering if these high-volume email sends
can have a serious effect on performance? Since I assume the
answer is yes, what can be done to lessen this impact? I see
two main spots to work on: Watchdog usage and email load.<br>
</span></div>
<div> </div>
<div><font color="#ff007f" face="bookman old style, new york,
times, serif" size="4"><i><strong>Nancy</strong></i></font></div>
<div><font face="arial, helvetica, sans-serif">Injustice
anywhere is a threat to justice everywhere. -- Dr. Martin L.
King, Jr.</font></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
</body>
</html>