I have several content types which will store thousands of records each one. Those content types will be related to each other as in a classic 1..N or N..M relationships I would like to query those content types taking this relationship into account.
I have searched for this on d.o but I am puzzled with the big quantity of modules available.
For instance is
entity reference any good for this ?
What is the best way to model the classic entity-relationship model of the database systems ? Also, will I be able to tune the database (mainly create new indexes) to increase the performance of the queries ? I am asking this because I will need to tune the database because of the big amount of data, so this is something to take into account at the time of considering different approaches to the modeling decision.