Which module for relationships in my particular case? Possible Duplicate:
  Relation vs. References vs. Entity Reference for managing node-reference-type relationships in D7  




I want to figure out which module (and, probably, strategy) will fit my needs best in such a situation.

I've built a site, there are a lot of piece's; each piece is either written or arranged by some person (or has both relations, composer and arranger); each piece can be a part of a collection (think of CD for performed piece's or book for scores in PDF).

Here piece, person, collection are types (post types, or node types in Drupal I believe); score, audio, video, text etc are taxonomies (in media tree). And each piece can have any or all media taxonomies assigned. Also there are genre taxonomies.

A person can be a conductor (if piece presents some performance by choir), soloist etc.

So, piece can be connected with person by a named "role".

Below are some links to demonstrate what I actually want to have (or something like that); the site made with WordPress (using posts-to-posts plugin).

However, I don't like what I have: that was the first my attempt to make a site, I am nor a programmer neither designer... I don't know what I am. Anyway, I don't like that site in terms of code maintainability (I guess that's my fault, not WP's), so I'd like to rewrite it; and I'd like to design new theme and have better ("overall php+mysql") performance.

So, now the question is: which module should I try for this --- Entity Reference or Relations? Or any other? Can I hope I can get better performance (php+mysql)?

Please, take a look (everything in Ukraine, but there are buttons to google-translate, SORRY):


here is Mykola Gobdych's page (conductor of Chamber Choir "Kyiv") --- below the photo there are links to other "views" (listen to pieces conducted by this person, listen to pieces performed by him, listen to his pieces --- either composed or arranged by --- etc)
some collection of piece's
a piece --- please, note, here are two performances... actually these are two piece's connected with "the same piece" relationship
listen to choir view


I really would like to try to do something like this with Drupal; however, I am very new to drupal. And I am not a programmer .)

So, please help; I will appreciate any helpful information or suggestion.

Thanks!
Both Entity Reference and Relation modules would do the work, but in your case I would suggest to go with Entity Reference module, since you don't have very complex relationships.