Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • Back of the envelope calculation: how many queries and in what timespan? Are you 100% certain this will saturate the link? Commented Jan 22, 2021 at 8:05
  • @Kain0_0 I was wondering the reason you were asking this? Is it because view is not necessarily better to handle large RPS, or are there other clear cons that makes view not a good choice in my use case unless the rps is really very large? Commented Jan 22, 2021 at 23:07
  • I'm not to sure what your actual use case is. How tolerant is this application to stale data? Does the relevant data contain an audit history (append only or at least an update strictly increasing timestamp)? The reason I asked if you had a fermi estimation (or even better empirical results) is that a materialised view is not transparent, it does have subtle implications for the validity of the data it contains, and as such is not a drop in solution. The easiest solution is to not have it, so have you actually checked that it is needed? Commented Jan 24, 2021 at 21:59