Discussion posts and replies are publicly visible
This is very dependent on a few factors you didn't mention, such as 1) your use case overall, and 2) the particular implementation of the view including any inefficient/complicated logic or JOIN operations.
Yes, definitely need some additional info on your use case here. For example, I have a view with 5.9 million rows which is queried constantly with great performance. I have another view over a table with 50k rows which performs much less efficient.
How complex is your view? How much data are you attempting to return at once / are you utilizing paging properly? Is indexing applied in the DB?
https://community.appian.com/w/the-appian-playbook/967/an-introduction-to-query-optimizationthis might be useful!