[support] General Drupal question

[Joel Willers]

So, if there were “many to many” data structures along with “one to many” structures (which node references are, if I understand them correctly), do I lose performance doing them with node references rather than hard coding the schema and interaction and storage?

 

Basically, if I have the data structure and interaction already mapped out, and all the tables already designed, how much performance do I lose by setting up Content Types and Node References versus just creating the table manually, and writing PHP to control the data flow? 

 

Time-wise, I realize it’s much, much easier to do Content Types and Node References.  It’s like 1/10th the time.  But if Node References are going to hit the memory on the server too hard and cause performance issues and delays, then it just isn’t going to work.  

 

Thanks for the feedback on this, by the way!  I really appreciate it!

 

Joel

 

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On Behalf Of Ms. Nancy Wichmann
Sent: Thursday, April 28, 2011 6:25 PM
To: support at drupal.org
Subject: Re: [support] General Drupal question

 

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.

 

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.
 

Nancy

 

Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

 

 

________________________________

From: Joel Willers

 

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. 

 

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?  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110429/6687d5f6/attachment.html