For the following example, let's consider the movie dataset.
Let's say we wanted to add a NOMINATED relationships between certain actors for different nomination e.g. Best Actor, Best Supporting Actor, etc. Let's say I wanted to query and find how many actors were nominated for Best Actor. Now, which of the following is more efficient?
- a NOMINATED relationship type, with a field/attribute/property with the following key-value pair of "type: Best Actor" and index that property using the db.index.fulltext.createRelationshipIndex
OR
- Have a relationship type for each nomination type i.e. NOMINATED_BEST_ACTOR, NOMINATED_BEST_SUPPORTING_ACTOR, etc
My feeling is either there is no difference (unlikely) OR the latter should be more performant of a query.
Thoughts?