Where should I store a data table [ViewState/ Session/ Cache]

Question

I have a DataTable with about 10,000 rows in it.

I would like to store this data once for aspx page. When the user selects different options in the page, data is further selected from the already stored DataTable.

I tried using the ViewState, but as soon as the data grows beyond 100 rows, performance degrades.

Where should I store this data?

Answer 1

Is the data on a per-user basis or is it global for all users? If it's global, use Cache. If it's user-specific, the traditional answer is to use Session, but that's a potential memory usage problem waiting to happen. You might just have to requery the database as needed.

ViewState has a more specific use, and it not suitable for large amounts of data, since all of that data is sent between the client and server in the webpage.