Results 1 to 5 of 5

Thread: Is it good to store dataset in session?

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2010
    Posts
    478

    Is it good to store dataset in session?

    I am working to find out memory leaking for one asp.net app.
    I found a article below:

    http://community.sgdotnet.org/blogs/...-variable.aspx

    Is it good to store a dataset in session?

  2. #2
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Is it good to store dataset in session?

    I would say it's not scaleable to store a dataset in session.

    Why do you need to do that?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  3. #3
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    6,763

    Re: Is it good to store dataset in session?

    Maybe for a local company inner site but other than that no it will eat memory and if it's very big your site may go down.
    ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
    πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·

  4. #4
    Fanatic Member
    Join Date
    Nov 2006
    Posts
    589

    Re: Is it good to store dataset in session?

    Quote Originally Posted by aspfun View Post
    I am working to find out memory leaking for one asp.net app.
    I found a article below:

    http://community.sgdotnet.org/blogs/...-variable.aspx

    Is it good to store a dataset in session?
    Why not store it in ViewState?

  5. #5
    Addicted Member Kamienios's Avatar
    Join Date
    Dec 2009
    Location
    Warsaw, Poland
    Posts
    159

    Re: Is it good to store dataset in session?

    Storing valuable data in session keys is not a good idead also because sessionId is stored in browser cookie as a normal text. So everyone could easily steal your session and read it`s data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width