←back to thread

121 points b-man | 1 comments | | HN request time: 0s | source
Show context
AnonHP ◴[] No.44026428[source]
Seems like this article places too much emphasis on normalization, which is appropriate for many cases, but may be a huge cost and performance issue for requirements like reporting. You may probably need different kinds of schema and data storage structures for different requirements in the same application, which in turn may result in duplicated data, but results in acceptable trade offs.
replies(3): >>44026517 #>>44026552 #>>44026719 #
zeroCalories ◴[] No.44026719[source]
Putting aside performance implications, I get kinda irritated by having to do joins for basic queries all the time.
replies(2): >>44030411 #>>44030636 #
1. datadrivenangel ◴[] No.44030636[source]
If you're doing reporting, create a reporting view that does all those joins once!