Drupal.org is also running on a cluster of servers that have been scaled over a longer period of time by people that know what they're doing.

On Mar 8, 2012 8:08 AM, "Ms. Nancy Wichmann" <nan_wich@bellsouth.net> wrote:
Let's see, Drupal.org has more than 10 times the nodes plus many more comments. It runs D6 and uses Views. And it is usually fast enough.
 
Nancy
 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.


From: Sam Cohen


The client currently has a searchable database of a 115,000 records written in cold fusion in a separate database on a separate server. 

They would like me to bring it into their Drupal 6 site or at least onto the same server.

I can do this in two ways:
1.   As a custom module running off it's own db.
2.  Or I can make it a content type and use Views for the interface. 

My preference is to just use CCK/Views for maximum flexibility -- but I question whether or not it's wise to add a 115k records to the node and other tables and what type of impact this might have on overall site performance.  (Any other downsides?)

Anyone have any advice/suggestions?  If it was your project would you code it separately or use CCK/Views.