Can i store the Datatable into ViewState with the records of

Question

I am trying to store the datatable in to viewstate so that next time i can get the records from viewstate instead a new query from database, But it is working very good on Localhost but on server it is taking too much time with same code and same SPs.

or tell me is there any other way to do the same thing so that i can get the data from client side without any repeated hits on server.

Ravi Shekhar · Answer

Hi Viewstate is not good way to store datatable. Viewstate is not able to store huge records. Regards ravi

Iftikar Hussain · Answer

Hi If your resultant table contains more record then it will slow. Instead you can use table caching if you know that the result will be not change for different user. Regards Iftikar

Riyaz Akhtar · Answer

If datatable contains common records for all users then u can use caching else session. if no of users is more in your application then session will also cause performance issue so be careful when u choose session.

Jaganathan Bantheswaran · Answer

Why not to use Session?