The materialized view pattern can promote a big increase in performance. This is because any data is read without performing joins or calculus to retrieve the data. However, if the data changes too rapidly, the materialized view will be rebuilt more times than necessary, which will impact performance.
The benefit of using the materialized view pattern is inversely proportional to the speed of changes in the original data. Therefore, the use of a materialized view is recommended when data is rarely modified and is not dynamic.