# Number of Materialized Views and Impact on Performance

**URL:** <https://forum.scylladb.com/t/number-of-materialized-views-and-impact-on-performance/1508>\
**Category:** ScyllaDB\
**Tags:** performance, materialized-views\
**Created:** [April 22, 2024, 8:45am UTC](https://forum.scylladb.com/t/number-of-materialized-views-and-impact-on-performance/1508 "2024-04-22T08:45:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guy](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/guy/32/9_2.png) [@Guy](https://forum.scylladb.com/u/Guy)\
**Post date:** [April 22, 2024, 8:45am UTC](https://forum.scylladb.com/t/number-of-materialized-views-and-impact-on-performance/1508/1 "2024-04-22T08:45:16Z")

</div>

> [@](#):
>
> [**Originally from the User Slack**](https://scylladb-users.slack.com/)
> 
> ![Benaceur_Ayoub](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/e711b4ff72efa6b12ec1305f6720316ee107540f.jpeg) **@Benaceur\_Ayoub:** Hi, if I have 7 materialized views on one table to support some queries would that hurt performance too much? Also what’s the maximum mv tables you can have per table ?
> 
> ![Felipe_Cardeneti_Mendes](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/233a9d524fbc97e39f08633c16b3dd2575d1d1f4.jpeg) **@Felipe\_Cardeneti\_Mendes:** There’s no pre-defined maximum as its down to your own judgement. Considering every view has a distinct key not part of the base table, then every write operation will require \* VIEW\_COUNT view updates.
> 
> If you run 1 ops/sec, that’s 8 updates (base table + 7 views). If you write 100K/s, that’s 800K updates.
> 
> The former is fine. The latter is likely not going to scale well.