search

TheCandidStartup / TheCandidStartup.github.io

The Candid Startup Blog
https://www.thecandidstartup.org
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

2023/07/10/denormalized-relational-database-grid-view #26

Open utterances-bot opened 9 months ago

utterances-bot commented 9 months ago

Denormalized Relational Database Grid View

We’ve been good. We’ve followed the rules. Our database is fully normalized and we have all the referential integrity checks we need in place. And yet. Our queries seem overly complex. There’s a constant battle to try and keep queries scalable. Despite all that, performance is not what we’d like.

https://www.thecandidstartup.org/2023/07/10/denormalized-relational-database-grid-view.html

Wayne82 commented 9 months ago

I very much agree with this statement "Relational databases are amazing pieces of technology. There’s a temptation to find new and creative ways of using them that stray far from the confines of normalized design. Unfortunately, when you’re way out on the cutting edge you’re going to run into all kinds of practical difficulties that are hard to foresee when you start the journey" Furthermore, a lack of sufficient understanding of the problem at hand, plus a lack of proficiency in database technology, can both potentially lead to the deviations described here.