<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body 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>
<br>
--Larry Garfield<br>
<br>
On 07/28/2011 02:57 PM, Dipen wrote:
<blockquote
cite="mid:CANFHyw=Y7f-URSywcX0ZDCG=jpVy8_DRPhnpMKD7nPSkFTZjeA@mail.gmail.com"
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">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 class="im"><br>
-----Original Message-----<br>
From: <a moz-do-not-send="true"
href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>
[mailto:<a moz-do-not-send="true"
href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>]
On<br>
</div>
Behalf Of Brett Evanson<br>
Sent: Thursday, July 28, 2011 3:26 PM<br>
<div>
<div class="h5">To: <a moz-do-not-send="true"
href="mailto:support@drupal.org">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">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">support-bounces@drupal.org</a>
[mailto:<a moz-do-not-send="true"
href="mailto:support-bounces@drupal.org">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">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 class="h5">[ 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>
</body>
</html>