loading...

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