DEV Community

Discussion on: Centralize Your Query Logic!

blackcat_dev profile image
Sasa 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

dmfay profile image
Dian Fay Author

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.

citizen428 profile image
Michael Kohl

Resurrecting an old discussion, but I find that many people actually mean "materialized view" when they say "view", because the only time they use them is to get over some performance bottleneck.