<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I suspect that's because it's the easiest number available to define
"site size". It just happens to be a particularly useless one. :-)<br>
<br>
Expects anonymous hits/second and authenticated hits/second are far
far more useful metrics. The next important consideration is site
complexity, which has no easily-measured value. (How many views,
how complex they are, how many on one page, whether they're
cacheable or not, how often content will be updated, how many shared
fields there are, etc. all go into "complexity".) <br>
<br>
Perhaps someone should make a practice of correcting that
misconception in the High Performance group. :-)<br>
<br>
--Larry Garfield<br>
<br>
On 07/29/2011 01:21 AM, Dipen wrote:
<blockquote
cite="mid:CANFHywk1VXgH-+-v9=cQb7PzYPCroMf3eGRFjNGDn9yhBU2zFA@mail.gmail.com"
type="cite">Thanks larry and ursula for your comments.
<div><br>
</div>
<div>The reason I asked it was that lot of times on
highperformance drupal group and on mailing list people ask for
performance recommendations citing number of nodes and nobody
seemed to correct them or mention that number of nodes doesn't
affect performance as much as other factors do (in fact upto
certain high number, it doesn't affect performance at all)</div>
<div><br>
</div>
<div>Thanks again</div>
<div>----------------------------------<br>
Dipen Chaudhary<br>
Founder, QED42 : We build beautiful and scalable web strategies
( <a moz-do-not-send="true" href="http://www.qed42.com">www.qed42.com</a>
)<br>
Blog: <a moz-do-not-send="true"
href="http://dipenchaudhary.com">dipenchaudhary.com</a><br>
Twitter: <a moz-do-not-send="true"
href="http://twitter.com/dipench">http://twitter.com/dipench</a><br>
<br>
<br>
<br>
<div class="gmail_quote">On Fri, Jul 29, 2011 at 9:08 AM, Larry
Garfield <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:larry@garfieldtech.com">larry@garfieldtech.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"> The only place where
node count would have a strong negative correlation to
performance would be if you had some inefficient,
unindexable queries. In that case, more nodes/records
=> slower queries. If your queries can all leverage
proper indexes, however, then you should be able to scale
to a few hundred thousand nodes, or a million nodes,
without too much trouble. My largest site is closing in
on 500k nodes, and all of the performance problems I've
ever run into have been due to bad/stupid queries or
brain-dead PHP code. (I recall CCK in D5 does a select on
all nodes that a nodereference could possibly point to for
validation. If you have 400,000 nodes, that will die.
That's not an SQL problem, that's a CCK in Drupal 5 was
brain-dead stupid problem. <g>)<br>
<br>
If your site is mostly anonymous, then that doesn't matter
much as most pages will be cached anyway. Throw varnish
in front of it and you will rarely even be bootstrapping
Drupal.<br>
<br>
If you need to get more performance out of a site for
authenticated users, switch to memcache for caching (saves
wear and tear on the SQL DB), leverage Views caching, and
build your site with Panels to get the per-pane caching
options. (Page caching has no effect for authenticated
users.)<br>
<br>
There's a TON that goes into performance optimization.
Content size is way down on the list. :-) <br>
<font color="#888888"> <br>
--Larry Garfield</font>
<div>
<div class="h5"><br>
<br>
On 07/28/2011 02:57 PM, Dipen wrote:
<blockquote type="cite">This comes up a lot and
logically and technically I don't really find
pressing co-relation between number of nodes and
performance of the site. I always view performance
as types of pages on the site (panels, views, full
node), types and number of modules used, type of
traffic (authenticated vs anonymous) but have failed
to find reasons that a site with more number of
nodes will suffer performance wise in a considerable
way, yes the table size would be large, number of
rows will be more so yeah there is lag in seek time
but really that doesn't matter much I feel ( and I
may be totally off ).
<div> <br>
</div>
<div>To cut short, is there a rationale to co-relate
number of nodes to performance? If yes, in what
ways. I might be missing something really basic,
but then yeah I have been asked this many times
and I usually dont give much weight-age to number
of nodes. I feel its more imp to asses num and
types of modules used, types of pages on the site
( is the site too much panels, views dependent )
and type of traffic. </div>
<div><br>
</div>
<div>Would love to hear your thoughts. </div>
<div><br>
</div>
<div>P.S My experience so far is with a site around
100-110k nodes. <br>
<div><br>
</div>
<div> Cheers<br>
<br>
<div class="gmail_quote">On Fri, Jul 29, 2011 at
1:03 AM, Gregg Marshall <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:mimlist@repconnection.com"
target="_blank">mimlist@repconnection.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:
0pt 0pt 0pt 0.8ex; border-left: 1px solid
rgb(204, 204, 204); padding-left: 1ex;"> I
think it was on the Pressflow website I read
about the modifications to<br>
Drupal.org in a comparison table.<br>
<br>
Gregg Marshall<br>
<div><br>
-----Original Message-----<br>
From: <a moz-do-not-send="true"
href="mailto:support-bounces@drupal.org"
target="_blank">support-bounces@drupal.org</a>
[mailto:<a moz-do-not-send="true"
href="mailto:support-bounces@drupal.org"
target="_blank">support-bounces@drupal.org</a>]
On<br>
</div>
Behalf Of Brett Evanson<br>
Sent: Thursday, July 28, 2011 3:26 PM<br>
<div>
<div>To: <a moz-do-not-send="true"
href="mailto:support@drupal.org"
target="_blank">support@drupal.org</a><br>
Subject: Re: [support] What is the
largest Drupal site as far as the number<br>
of rows within the node table and how is
the performance?<br>
<br>
If you're looking for drupal
performance, look at Mercury or<br>
Pressflow. Those are great places to
start.<br>
<br>
Brett Evanson<br>
<br>
<br>
<br>
<br>
<br>
On Thu, Jul 28, 2011 at 1:16 PM, Gregg
Marshall<br>
<<a moz-do-not-send="true"
href="mailto:mimlist@repconnection.com"
target="_blank">mimlist@repconnection.com</a>>
wrote:<br>
> And I vaguely remember reading
somewhere that Drupal.org is not a stock<br>
> Drupal installation but has been
modified to aid its performance.<br>
><br>
> Gregg Marshall, CPMR, CSP, CMC<br>
><br>
> -----Original Message-----<br>
> From: <a moz-do-not-send="true"
href="mailto:support-bounces@drupal.org"
target="_blank">support-bounces@drupal.org</a>
[mailto:<a moz-do-not-send="true"
href="mailto:support-bounces@drupal.org"
target="_blank">support-bounces@drupal.org</a>]
On<br>
> Behalf Of Earnie Boyd<br>
> Sent: Thursday, July 28, 2011 1:03
PM<br>
> To: <a moz-do-not-send="true"
href="mailto:support@drupal.org"
target="_blank">support@drupal.org</a><br>
> Subject: Re: [support] What is the
largest Drupal site as far as the<br>
number<br>
> of rows within the node table and
how is the performance?<br>
><br>
> John Mitchell wrote:<br>
>> What is the largest Drupal site
as far as the number of rows within the<br>
> node<br>
>> table and how is the
performance?<br>
><br>
> Uhhmm, I would guess <a
moz-do-not-send="true"
href="http://drupal.org"
target="_blank">drupal.org</a> to best
fit answer for that question and<br>
> you can see the performance for
yourself. Now it is run by top notch<br>
> server guru's who know how to tune
the performance which is what you<br>
> need for a heavy hitting site.<br>
><br>
> --<br>
> Earnie<br>
> -- <a moz-do-not-send="true"
href="http://progw.com"
target="_blank">http://progw.com</a><br>
> -- <a moz-do-not-send="true"
href="http://www.for-my-kids.com"
target="_blank">http://www.for-my-kids.com</a><br>
> --<br>
> [ Drupal support list | <a
moz-do-not-send="true"
href="http://lists.drupal.org/"
target="_blank">http://lists.drupal.org/</a>
]<br>
><br>
> --<br>
> [ Drupal support list | <a
moz-do-not-send="true"
href="http://lists.drupal.org/"
target="_blank">http://lists.drupal.org/</a>
]<br>
><br>
--<br>
[ Drupal support list | <a
moz-do-not-send="true"
href="http://lists.drupal.org/"
target="_blank">http://lists.drupal.org/</a>
]<br>
<br>
</div>
</div>
--<br>
<div>
<div>[ Drupal support list | <a
moz-do-not-send="true"
href="http://lists.drupal.org/"
target="_blank">http://lists.drupal.org/</a>
]<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
<br>
--<br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>