Opinion: Optimal way of holding large amounts of data between pages?

[David]

Suggestions for optimal ways to hold large amounts of data, ex. a
dataset, array, etc. between asp pages? Eg. place it in a viewstate,
session, cache, on a local DB, or even on disk.

This is critical if someone can ask for larger dataset requests and
have to page through them over the period of a few minutes. Cache is
suggested, but it may expire at any time and require re-loading data.

Thanks