3 ms·
No, see the FAQ in the readme: Materialized views solve a similar problem but in a different way with different trade-offs. When you have many users, all subsc
by eventreduce 6y ago
No, see the FAQ in the readme:
Materialized views solve a similar problem but in a different way with different trade-offs. When you have many users, all subscribing to different queries, you cannot create that many views because they are all recalculated on each write access to the database. EventReduce however has a better scalability because I does not affect write performance and the calculation is done when the fresh query results are requested not beforehand.
- dahauns 6y agoOthers have pointed this out already: This is wholly dependent on the RDBMS used, and Oracle offers incremental refresh on demand. I have to admit though that I mistakenly thought that MSSQL would as well...