Session or not?

[Ivan Demkovitch]

Hi!

I have general question:

Right now my website load some stuff from DB every time it get's hit
(IBuySpy)

I wonder if I get benefit by using session/application states to save data
and access it from there instead of hitting DB every time.

Would it help?

TIA

 

[Mohamed El Ashmawy]

Using Session and application state variables would increase the performance
of your application instead of getting the info from the DB each time.
Please design well on which should go in the application state and which
which should go in the session state.
Please review the msdn article at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspnet/html/asp12282000.asp
to get more information on Session State.

Regards
Mohamed El Ashmawy
MEA Developer Support Center
ITWorx on behalf of Microsoft EMEA GTSC