DEV Community

Centralize Your Query Logic!

Dian Fay on July 25, 2018

At a talk I gave earlier this month, an audience member asked if Massive supported joining information from multiple tables together. It's come up ...
Collapse
 
blackcat_dev profile image
Sasha Blagojevic

Another cool feature of Views is better performance compared to normal queries with multiple join statements especially in high traffic websites with a lot of records, or so I’ve heard from more senior devs, correct me if I’m wrong

Collapse
 
dmfay profile image
Dian Fay

This isn't an innate benefit of using (regular, non-materialized) views. As far as I know any performance benefit would be from the improved query consistency making it easier to hit the cache instead of having to read from disk.

Collapse
 
dmerand profile image
Donald Merand

I always learn something really interesting from your articles. It's fascinating to see the logic behind preferring views over joins, and how this relates to ORM.