Session Variables and reclaiming associated memory.

Discussion in 'ASP General' started by Mario, Feb 18, 2004.

  1. Mario

    Mario Guest

    If there is an associated memory cost for using session variables, can
    the memory used be reclaimed on an ASP page by setting the session
    variable to undefined or null? If on the same ASP page you use a
    different session variable name and after each refresh of the page,
    set the previous session variable to undefined before using the next
    session variable, does this reclaim the memory used in the previous
    session variable, or does the usage of memory just continue to grow
    with each page refresh?

    Tex
     
    Mario, Feb 18, 2004
    #1
    1. Advertisements

  2. Mario

    swp Guest

    (Mario) wrote in message news:<>...
    > If there is an associated memory cost for using session variables, can
    > the memory used be reclaimed on an ASP page by setting the session
    > variable to undefined or null? If on the same ASP page you use a
    > different session variable name and after each refresh of the page,
    > set the previous session variable to undefined before using the next
    > session variable, does this reclaim the memory used in the previous
    > session variable, or does the usage of memory just continue to grow
    > with each page refresh?
    >
    > Tex


    When you say "undefined" above do you mean "nothing" or ""?

    for example, which of these is appropriate to your situation:
    DIM con, rs, sql
    sql = "SELECT name, addr1, addr2, city, state, zip FROM people WHERE
    flag<>'D' ORDER BY name"
    set con = server.CreateObject("ADODB.Connection")
    con.Open db_name, username, password ' fill in with your own system
    dsn link and connectivity information
    set rs = con.execute(xsql)
    .... process stuff ...
    con.close
    set rs = nothing
    set con = nothing

    swp
     
    swp, Feb 18, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Earl Teigrob

    Global Session Variables and Session State

    Earl Teigrob, Dec 16, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    4,965
    Alvin Bruney
    Dec 17, 2003
  2. Replies:
    1
    Views:
    1,140
  3. Thomas Rast

    Reclaiming (lots of) memory

    Thomas Rast, Oct 2, 2004, in forum: Python
    Replies:
    11
    Views:
    741
    Luis P Caamano
    Oct 22, 2004
  4. =?Utf-8?B?Um9iSEs=?=
    Replies:
    4
    Views:
    5,868
    =?Utf-8?B?Um9iSEs=?=
    Apr 11, 2007
  5. CJ

    Reclaiming locks

    CJ, Oct 29, 2007, in forum: C Programming
    Replies:
    6
    Views:
    446
    David Schwartz
    Oct 30, 2007
  6. softwarepearls_com

    Reclaiming this group for Java enthusiasts

    softwarepearls_com, Sep 29, 2008, in forum: Java
    Replies:
    4
    Views:
    538
    Arne Vajhøj
    Oct 4, 2008
  7. Myth__Buster
    Replies:
    14
    Views:
    622
    Myth__Buster
    Feb 3, 2011
  8. Jazzis
    Replies:
    2
    Views:
    436
    Jazzis
    Sep 23, 2003
Loading...