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.
Loading

Ravi ShekharPosted Jul 12, 2013, 7:39 AM
Viewstate is not good way to store datatable. Viewstate is not able to store huge records.
Regards,
ravi
Iftikar HussainPosted Jul 12, 2013, 7:04 AM
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 AkhtarPosted Jul 12, 2013, 5:59 AM
if no of users is more in your application then session will also cause performance issue, so be careful when u choose session.
Jaganathan BantheswaranPosted Jul 12, 2013, 3:45 AM