<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>JOINs, for the most part, are not bad. "Lots of ... fields" may be more the issue. It might be a good time for rethinking the design. You do have a design document, don't you? This may be a case where a custom node module (single query without JOINs) may be a better choice. Or a faster CPU with more memory... Also get a DB expert to tune the DB settings for this set up.<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> Deva</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"></FONT><BR><FONT face=verdana,sans-serif>In my case i am going to have lots of content types with lots of cck fields.<BR>D7 creates new table for each cck field. So while reading a node from database. It is going to do a join. I dont think that is good thing. <BR><BR>That is why i was checking if it is possible to have different table for each content type. <BR></DIV></FONT>
<DIV style="TEXT-ALIGN: left; PADDING-BOTTOM: 0px; LINE-HEIGHT: 130%; MARGIN-TOP: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: times new roman, new york, times, serif; WORD-WRAP: break-word; VISIBILITY: hidden; COLOR: black; MARGIN-LEFT: 0px; FONT-SIZE: 10px; OVERFLOW: hidden; PADDING-TOP: 0px" id=avg_ls_inline_popup></DIV></DIV></div></body></html>