Link to home
Start Free TrialLog in
Avatar of mmalik15
mmalik15

asked on

Alternative to storing datatable in session in asp.net

Hi,

I understand that storing datatable in session variable in asp.net is bad since it will use a lot of server's mememory.  What's are the possible alternatives? In case my page need to display about 50 records pulled from sql server database for say 50 concurrent users.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Pratima
Pratima
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_6283346
Member_6283346

Hi! You can read data from database on every page request (get or post), without any caching. I guess it should not make your page too slow (you can optimize db connection, using connection pooling).