19th*, 20th & 21st February 2020 info@phpconference.co.uk @phpukconference

Video archive

How De-normalizing Your Data with JSON Can Boost Query Performance

Video details

Speaker: David Stokes
Length: 29:15


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.

Stay up-to-date with PHP UK

Enter your email address to join the PHP UK Conference mailing list and be the first to hear our latest news and announcements.