re: Centralize Your Query Logic! VIEW POST

FULL DISCUSSION
 

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

 

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.

 

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.

code of conduct - report abuse