Talk in English - UK at PHP UK Conference 2019
Short URL: https://joind.in/talk/698a3
(QR-Code (opens in new window))
Database joins can be expensive and you can reduce dives into the indexes/data by using JSON columns. By loading data kept in smaller 'stub' tables into main tables it is possible to minimize joins for simple data like address, phone numbers, and the like in schemaless JSON documents. Yes, third normal form or better has advantages at many levels but it is a design that is costly for many-to-many relations! It is very easy to refactor data is is often stagnant or infrequently updated to take advantage of hybrid SQL/NoSQL databases to greatly increase overall query performance plus increase code readability. This approach can completely change your ideas on data architecture and provide easy mutability for future changes.
Slides at https://slideshare.net/davidmstokes
Comments
Comments are closed.
Really great talk. Very clear examples. Really enjoyed it
I was expecting a bit more comparison and benchmark on how these things can work. Real-life examples would be great.
Also during the slides presenter went from guitars to some student records and then back to guitars which was strange.
Not quite what I was expecting. For starters, it only filled half the time, which was a bit disappointing. Felt like an announcement that MySQL supports JSON column types, except that that's old news by now, even if we're not all using it. Also disappointing that a talk billing itself on performance gains couldn't give any real-world benchmarks on what those performance gains would be.