<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV></DIV>
<DIV>Scaling? How many people are going to use this? It doesn't sound like many; budgets are not generally open to the world, unless it's a government site. So, I supect the first design point is to determine your target audience and how many they might be.</DIV>
<DIV> </DIV>
<DIV>Secondly, it's not content types that are the issue; it's nodereferences that are. It might be that you find that some of that is not needed. For example, departmental structure is generally not very fluid, so hand-coding the department names as a list in the content type might reduce the level of performance issues considerably.<BR> </DIV>
<P><FONT color=#ff007f size=4 face="bookman old style, new york, times, serif"><EM><STRONG>Nancy</STRONG></EM></FONT></P>
<P> </P>
<P><FONT face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></P>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR><FONT size=2 face=Tahoma>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<HR SIZE=1>
</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Joel Willers</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </FONT></DIV>
<STYLE><!--
_filtered {font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered {font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"sans-serif";}
a:link, span.MsoHyperlink
{
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{
color:purple;
text-decoration:underline;}
span.EmailStyle17
{
font-family:"sans-serif";
color:windowtext;}
.MsoChpDefault
{}
_filtered {
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{}
--></STYLE>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt" class=WordSection1>
<P class=MsoNormal>I have a site that I’m working on the data structure for… I feel like I know how I’d do it, but I was told that it might not scale well, so I thought I’d run it through you guys. </P>
<P class=MsoNormal> </P>
<P class=MsoNormal>Would this cause too much server load using inherent Drupal Content Types with CCK fields (D6)? Would it only work with direct db queries and mysql tables instead? How much is lost doing it using content types instead of custom coding? </P>
<P class=MsoNormal> </P></DIV></DIV></div></body></html>