I have a much more complex view over almost 2M items, no problems. It’s less about the complexity and more about how fast the data changes. Performance is good for either stale queries or if the rate of change is something your system can keep up with.
As far disk space usage is concerned, the storage is snappy compressed, so that should help a little. It doesn’t help a lot with small records though. You should be able to calculate what’s needed from the size of the objects as an upper bound.