4 ms·

Sooo...Materialized/Indexed Views?

• eventreduce 7y 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 7y ago
    Others 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...
• dfgdghdf 7y ago
  Correct me if I'm wrong, but Materialized Views have the limitation that you need to refresh the entire view! Often you know which rows will change based on the data you receive.
  • taffer 7y ago
    This depends on the RDBMS. Oracle for example has incremental materialized view updates.