re: In RMDBS is join table bad for perfomance ? VIEW POST


Normalization is about the relationship between entities.
Joins is about using that relationship to narrow down the result when querying.

You could still have a normalized database, but perform queries without using joins for extra speed.
You will get it, but at a cost elsewhere. (e.g you have to write code in your application that puts data from multiple queries together).

Personally, I would try all possible optimization technics first (wiki.postgresql.org/wiki/Performan...) before avoiding joins. There's a lot of them. Also, high-performance hardware should be considered too.


I see, that make sense, thank you

code of conduct - report abuse