Re: 115,000 records -- nodes or custom

FWIW, Drupal.org does not make heavy use of CCK (change nodes, and a few
other types are some of the first content types built mostly on CCK).
Projects and especially the issue queue make use of custom tables, and
highly tuned views, using multiple instances of denormalization for
performance.

Ms. Nancy Wichmann 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.
> 

-- 
__________________
Michael Prasuhn
503.512.0822 office
[email protected]