I was wondering what would the difference in performance for the following two scenarios
app with 10 millions rows by 500 users an
aggregate app to 200,000 row but when making a selection on chart would lead to that same 10 millions app but opening it using document chaining for a particular selection, this scenario will e used by 500 users
I think a document chaining won't have a real positive effect because quite likely there are always some users which are not just looking on the aggregated app else they will go to the chained detail-app and therefore you will get two apps which are handled in parallel from the server. It will need more resources than a single app.