By notabenem on
Guys,
I've run into a new challenge. I would be nice if someone could advice, what's better.
Goal: have 3 different content types: competitor, event, result
result is related to event and competitor
The questions is, whether it is effective, if "result" will be a VERY simple content type, with basically 2 node references (event and competitor) and a decimal field: final placement...
I know that drupal was not meant to work like this, but using CCK/Views and NoreReferrer this is achievable. But will it be effective even with a high number of nodes? Will it be easy to select the related nodes, like from over >100 events?
Can it be achieved using a different technique?
M.
Comments
Sure it was meant to work
Sure it was meant to work like this. And 100 events doesn't sound like too much.
About performance, it depends. As they do in practical database design, sometimes you have to avoid too many "joins", but it is hard to know if there is any serious reason to make concessions in the design.
I think it shouldn't be a
I think it shouldn't be a problem and as far as I'm concerned, this is exactly what Drupal+CCK+nodereferrer is supposed to do.
The only thing I don't understand is: why have separate content types for event and result? Isn't it a 1:1 relation, or in other words, doesn't 1 event always have 1 result? In that case, I guess performance would be better if the 'result' field and 'competitor' node reference are just two fields in the event content type. I guess this would also make maintainance easier: After the event, you could just edit the event node and add the result instead of creating a new node.
From what I can understand
From what I can understand from the explanation, "result" was not the result of an event but the result of one competitor in an event. So it might be useful for a view field listing such "results" in a competitor node or in an event node.
It was exactly meant as you said
Yes, it was exactly meant as you said.
And you seem pretty much confident, that using nodereferrer is the way to do it... so off we go :)
Thanks for the help.
-M.