To relate, or not to relate, that's the question

Oh, so it’s not computing all the relations with each change in the database?
Could you perhaps provide an example for when NOT to use relations, but have duplicate data instead? (or any other solution)

This is bringing us back to the discussions about the 25K limit.