top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What are the advantages and disadvantages of SqlServer Session mode?

+5 votes
96 views
What are the advantages and disadvantages of SqlServer Session mode?
posted Dec 11, 2014 by Manikandan J

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Advantages:

(1) Session provide us the way of maintain user state/data.
(2) It is very easy to implement.
(3) One big advantage of session is that we can store any kind of object in it. :eg, datatabe, dataset.. etc
(4) By using session we don't need to worry about data collesp, because it store every client data separately.
(5) Session is secure and transparent from the user.

Disadvantages:

(1)Performance overhead in case of large volumes of data/user, because session data is stored in server memory.
(2) Overhead involved in serializing and de-serializing session data, because in the case of StateServer and SQLServer session modes, we need to serialize the objects before storing them.

answer Dec 14, 2014 by Shivaranjini
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...