In my experience with a large database-driven web-site (custom, non-drupal, with several tables in the 20-400 million rows range), the query construction/table layout is much more important than the number of entries in the tables (to a certain point, of course, the server needs to be able to handle large tables like this). <br>
<br>So, I totally agree with Dipen, that the type of pages and the type of traffic are more important for the performance of a site than the number of nodes. <br><br>Switching on the query log using the development module helps pinpointing slow performing tasks. And if the site warrants it (either high traffic site or the possibility of re-using the module in a number of similar sites), it might be better for performance to create a custom module with specific functionality. <br>
<br>Ursula<br><br><br><br><div class="gmail_quote">On Thu, Jul 28, 2011 at 12:57 PM, Dipen <span dir="ltr"><<a href="mailto:dipench@gmail.com">dipench@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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<div><div></div><div class="h5"><br><br><div class="gmail_quote">On Fri, Jul 29, 2011 at 1:03 AM, Gregg Marshall <span dir="ltr"><<a href="mailto:mimlist@repconnection.com" target="_blank">mimlist@repconnection.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;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 href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a> [mailto:<a 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></div><div>To: <a 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 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 href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a> [mailto:<a 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 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 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 href="http://progw.com" target="_blank">http://progw.com</a><br>
> -- <a href="http://www.for-my-kids.com" target="_blank">http://www.for-my-kids.com</a><br>
> --<br>
> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
><br>
> --<br>
> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
<br>
</div></div>--<br>
<div><div></div><div>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br></div></div></div></div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>