Good, simple solution could be data duplication, eg. store some props from the joined tables directly in the main table. I know, for many, this is one of the d

Good, simple solution could be data duplication, eg. store some props from the joined tables directly in the main table. I know, for many, this is one of the deadly sins, but I think it can work out very well.