Sasa is a highly driven full stack software developer with background in finance and accounting. A relentless problem solver who is passionate about finding elegant solutions to problems at hand.
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
It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
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.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
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.