Skip to content

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 ( before avoiding joins. There's a lot of them. Also, high-performance hardware should be considered too.

code of conduct - report abuse