loading...

re: Centralize Your Query Logic! VIEW POST

TOP OF THREAD FULL DISCUSSION
re: Another cool feature of Views is better performance compared to normal queries with multiple join statements especially in high traffic websites wi...
 

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